DH Templates

Excel templates?

I was wondering is there an invoice template that would allow me to type the name of the company and automatically save the address. Or a way to save (in excel) the company name and address so the i only type the name of the company and have the address appear and not have to retype everything.

Public Comments

1. Excel won't do this. It does not store a datebase of records. Look into Quickbooks from Quicken/Intuit. They have some good invoicing features. They offer a free trial download to handle a limited number of clients.
2. DT is wrong. This is What Excel is made for. You can add a new worksheet with the database of Company names and address in column A and B. Then, in your invoice, in the cell that you want Excel to show the address (Assuming that the cell with the company name is D4), paste this: =VLOOKUP( D4, Sheet2!A:B,2, FALSE) Also assume that the sheet name of the companies database is Sheet2 Enjoy my profile, I am the VBAXLMan