Create invoices from excel workbook
 

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.

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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.

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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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.

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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.

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.


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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.

can't you link the workbook to the invoices. to automatically update
certain fileds?
"KJH" wrote:

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.


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"KJH" schrieb im Newsbeitrag
...
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.