Home |
Search |
Today's Posts |
#1
|
|||
|
|||
creating many invoices with excel data
I need help with creating invoices (excel file) that have my individual
customers information from another excel file. To be more clear, I have a standard invoice (excel file) with name, address, and balance missing. I need to incorporate information from another excel file that have names in A, address in B, and balance in C. I need it to print out many invoices with each one containing one costumer info. Please help me.. Thank you |
#2
|
|||
|
|||
You could use Data Validation and Vlookup formulas to create an invoice.
There's an example he http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Invoice for Selected Number' creating many invoices from excel data wrote: I need help with creating invoices (excel file) that have my individual customers information from another excel file. To be more clear, I have a standard invoice (excel file) with name, address, and balance missing. I need to incorporate information from another excel file that have names in A, address in B, and balance in C. I need it to print out many invoices with each one containing one costumer info. Please help me.. Thank you -- 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 | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |