Create invoices from excel workbook

[Guest]

I would like to create invoices from an excel workbook.
I have all the data for each indivual invoice entered into the workbook.
I would like to be able to only type the data in the workbook and then have
it create and invoice for each row of the workbook. Right know I enter the
data in the workbook and then also enter it on the invoice form I have
created.

 

[Frank Kabel]

Hi
you need to provide some more details about your exact data structure and
your desired invoice layout

 

[Guest]

I have a spreadsheet that I enter all the data for my invoice. I enter the
weight of the product and the price plus the ship date and billing date.
Then I have to go and enter the same data on the invoice form I created. But
I would like to only enter the data on the spreadsheet and have it then
automaticaly entered onto the invoice form I created. But I need it to do
this for every row in the spreadsheet. So I will have multiple invoices from
my monthly spreadsheet.

KJH

 

[Frank Kabel]

Hi
I'd use mail merge in this case (combine Word and Excel). See:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

 

[Guest]

Thanks I will try this. I never thought of using word. I haven't used mail
merge much so hopefully I can figure it out.

 

[Guest]

can't you link the workbook to the invoices. to automatically update
certain fileds?