alandrigan
New Member
- Joined
- Mar 18, 2009
- Messages
- 3
Hi Everyone,
I just put together an invoice spreadsheet for a company I would like to start and it consists of 2 worksheets
1) The actual invoice template
2) The database worksheet which contains client info, and some other dropdown list items
I have figured out all the basic drop down menus and functions. However I would like to make it so that I can select the Company Name from the invoice template worksheet from the first drop down, and based on this, I need a formula which will search the Database Worksheet and plug in the rest of the client information on the proceeding lines (address, etc etc in red)
Any and all help and direction much appreciated. Anyone is free to use this file for personal use if interested
http://www.canadianpolicing.com/HELP_TEMPLATE.xls
I just put together an invoice spreadsheet for a company I would like to start and it consists of 2 worksheets
1) The actual invoice template
2) The database worksheet which contains client info, and some other dropdown list items
I have figured out all the basic drop down menus and functions. However I would like to make it so that I can select the Company Name from the invoice template worksheet from the first drop down, and based on this, I need a formula which will search the Database Worksheet and plug in the rest of the client information on the proceeding lines (address, etc etc in red)
Any and all help and direction much appreciated. Anyone is free to use this file for personal use if interested
http://www.canadianpolicing.com/HELP_TEMPLATE.xls