Hey Guys,
I have an invoicing spreadsheet I'm working on. Sheet 2 has essentially a 'database' that is always being added to. This consists of columns with headers/fields. Running across the rows is the relevant information for each customer.
Sheet 1 is the invoice itself.
I would like to be able to add the details per customer into sheet 2, in database style format. Then pull the information into Sheet 1 to fill out the invoice so I can print to send to customer.
Has anyone had any experience with this kind of thing?
I have attached a simple example here:
http://www.handiliteskylights.com.au/misc/Display_User.xlsx
Thanks for any help!
Regards,
Glen
I have an invoicing spreadsheet I'm working on. Sheet 2 has essentially a 'database' that is always being added to. This consists of columns with headers/fields. Running across the rows is the relevant information for each customer.
Sheet 1 is the invoice itself.
I would like to be able to add the details per customer into sheet 2, in database style format. Then pull the information into Sheet 1 to fill out the invoice so I can print to send to customer.
Has anyone had any experience with this kind of thing?
I have attached a simple example here:
http://www.handiliteskylights.com.au/misc/Display_User.xlsx
Thanks for any help!
Regards,
Glen