Excel merge or data form (for invoice)..help!!

[LeeAnne]

I am trying to create invoices
Date, description, amount per, amount
I have this already created in an excel form and I want to transfer this
into the invoice I have created in excel. How can I transfer this info into
the cells and print invoices one at a time with the info from the
worksheet...its kind of like a filling in of a form letter...

Does anyone understand what I am asking...HELP

 

[Debra Dalgleish]

You can use the VLOOKUP function to return the details after you have
entered the invoice number. There are instructions in Excel's Help, and
here;

http://www.contextures.com/xlFunctions02.html

To make it easy to enter the invoice numbers, you can use a Data
Validation list. There are instructions here:

http://www.contextures.com/xlDataVal01.html

There's a sample invoice that uses data validation and VLookup formulas
here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Invoice for Selected Number'