Question about Microsoft Excel for PC
I'm generating every day 100-150 invoices in Excel.
Every time I'm entering Customer Name & Address and other details.
So, I want to minimize my data entry. my Idea is I will enter all customer names & Addresses in separate data file with customer ID No.
At the time of Invoice generation I will key only Customer ID #.
Automatically Customer name and Address to update/write in my Invoice transaction file.
please guide me step-by-step
* first-of-all how do I create customer master (source) file
* and how to link that source file and invoice transaction file
please solve my problem
thanks and regards
Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.
Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.
Posted on Jan 06, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 08, 2014 | PayPal Computers & Internet
May 02, 2011 | Pc America Restaurant Pro Express
Oct 31, 2010 | Tally Computers & Internet
Oct 14, 2010 | eBay Auctions
Jun 12, 2009 | Microsoft Excel for PC
Mar 04, 2009 | Microsoft Computers & Internet
Feb 26, 2009 | Microsoft Excel 2000 Step by Step...
May 14, 2008 | Microsoft Excel 2000 Step by Step...
Apr 25, 2008 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
112 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: