hello,
i have an excel database containing information related to invoice:
[invoice #] [invoice date][invoice details] [...]
i have a template for the invoice that i would need to be populated for each line in the database and each line to be using the template shoulb be inserted in a separate spreadsheet that would have the name as the [invoice #]
for example: for the first line in the excel detabase
23334 23-jun-11 test invoice
there should be created a new spreadsheet named 23334 and the
23-jun-11 should go on cell I3 and test invoice on cell I7
this should be repeated for the rest of the invoices
can someone help me with this?
i have an excel database containing information related to invoice:
[invoice #] [invoice date][invoice details] [...]
i have a template for the invoice that i would need to be populated for each line in the database and each line to be using the template shoulb be inserted in a separate spreadsheet that would have the name as the [invoice #]
for example: for the first line in the excel detabase
23334 23-jun-11 test invoice
there should be created a new spreadsheet named 23334 and the
23-jun-11 should go on cell I3 and test invoice on cell I7
this should be repeated for the rest of the invoices
can someone help me with this?
