T
Toby
Hi All,
I want to use stored data on one Worksheet to produce a printable form in
the form of a certificate on another worksheet.
I have produced a one page (A4) document using Excel 2003 which at present I
enter manually information into the required cells and then print that
document. As I have another Worksheet with stored records of the data I wish
to print onto these documents, one line per customer, is there a way that I
can combine the two Worksheets onto one file, call up a particular row and
then transfer the contents of the cells on that line to the required position
on the document in the other Worsheet and print.
I want to use stored data on one Worksheet to produce a printable form in
the form of a certificate on another worksheet.
I have produced a one page (A4) document using Excel 2003 which at present I
enter manually information into the required cells and then print that
document. As I have another Worksheet with stored records of the data I wish
to print onto these documents, one line per customer, is there a way that I
can combine the two Worksheets onto one file, call up a particular row and
then transfer the contents of the cells on that line to the required position
on the document in the other Worsheet and print.