Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel merge or data form (for invoice)..help!!
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 |
#2
|
|||
|
|||
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 he http://www.contextures.com/xlDataVal01.html There's a sample invoice that uses data validation and VLookup formulas he http://www.contextures.com/excelfiles.html Under Data Validation, look for 'Invoice for Selected Number' LeeAnne wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a data entry form template in Excel 2003? | Excel Discussion (Misc queries) | |||
merge excel form with excel datadase how can i do | Excel Worksheet Functions | |||
why can't I open my Excel data in Excel, but I can as a merge sour | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
How do I merge 2 Excel files, each with different names and data?. | Excel Discussion (Misc queries) |