how to automate invoice using excel database

G

Guest

I have our stock listed in excel and want to be able to type a quantity and
stock number into an invoice form and have it complete the details price and
description from the excel database. Can this even be done in excel. Have
seen many references to doing similar in access but not sure if I can in
Excel. i an using excel 2003. Any help greatly appreciated.
 
G

Guest

hi. very easy to use a vlookup function. i regualrly use this to fill in
customer data at top of form and then fill the invoice with qty, desc, price
and extension. check out the VLOOKUP function...to me it is one of the most
useful functions in excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

connect a form to excel database 5
Create Invoice in Excel? 2
How do I set up an automatic invoice number in Excel 2007 1
how to strip an individual symbol from each row in a column 1
inventory invoice 4
Invoice spreadsheet 3
Taking away from stock in excel 2007 1
How do I move data from Excel worksheet to invoice? 1

Top