I would like to create multiple invoices within the same workbook. I have Invoice #1 in my workbook. Invoice #2 begins as a copy of Invoice #1, then the necessary data is changed. Each of these invoices need to link to a single, flat-file database in Excel. So far so good.
Here's where I get lost. I need a way to provide each sheet (invoice) with a unique identifier so that when the invoice is changed / updated at a later date, the corresponding data is updated. The Template Wizard with Data Tracking works well for a workbook, but does not keep track of multiple sheets within a workbook.
Here's hoping the Tek-Tips Brain Trust can pull through on this one.
Thanks in advance,
Darin
Here's where I get lost. I need a way to provide each sheet (invoice) with a unique identifier so that when the invoice is changed / updated at a later date, the corresponding data is updated. The Template Wizard with Data Tracking works well for a workbook, but does not keep track of multiple sheets within a workbook.
Here's hoping the Tek-Tips Brain Trust can pull through on this one.
Thanks in advance,
Darin
