D
Dan Wilson
Good day. I'm not really a new user, but I am new to
using templates. I am running Excel 2002 and I have been
trying to learn how to use a template called Invoice.xlt.
I can make the template work manually and I have
customized it to my own company name, etc. However, I
need to know if there is a way to print merge the template
with data from an Excel worksheet containing a list of
vendors who have purchased products. The Excel worksheet
containing the data currently has 11 columns of data
containing the necessary items to be incorporated into the
invoice.
Whenever I enter a VLOOKUP formula into the Customer Name
field in the Invoice template, it does not recognize the
formula as a formula, rather it treats it as text.
I also noticed that there is no print merge function in
Excel? Am I missing something?
The Excel worksheet contains a column identified as the
flag number. This will become the invoice number. I
would like to be able to input the flag number into the
invoice template in the Order No. field and then have the
invoice extract all other data from the Excel worksheet
for that flag number. Can I do this? I have tried to
find help on templates, but so far no luck.
Thanks for any help. Danno...
using templates. I am running Excel 2002 and I have been
trying to learn how to use a template called Invoice.xlt.
I can make the template work manually and I have
customized it to my own company name, etc. However, I
need to know if there is a way to print merge the template
with data from an Excel worksheet containing a list of
vendors who have purchased products. The Excel worksheet
containing the data currently has 11 columns of data
containing the necessary items to be incorporated into the
invoice.
Whenever I enter a VLOOKUP formula into the Customer Name
field in the Invoice template, it does not recognize the
formula as a formula, rather it treats it as text.
I also noticed that there is no print merge function in
Excel? Am I missing something?
The Excel worksheet contains a column identified as the
flag number. This will become the invoice number. I
would like to be able to input the flag number into the
invoice template in the Order No. field and then have the
invoice extract all other data from the Excel worksheet
for that flag number. Can I do this? I have tried to
find help on templates, but so far no luck.
Thanks for any help. Danno...