ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   creating many invoices with excel data (https://www.excelbanter.com/excel-discussion-misc-queries/24274-creating-many-invoices-excel-data.html)

creating many invoices from excel data

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

Debra Dalgleish

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



All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com