Three page duplicate, modifiable worksheet possible?

[catrina616]

I'd like to create a template for a 3 part certificate in which data can be added to cells in the first sheet that will be automatically duplicated to the other 2 pages. I would need all three pages to print, and have inserted word art into the second and third pages (to act as a watermark).

Basically - a form that will be filled out differently each time its utilized, and it will be a three part identical form that needs to print all at once with one command.

Any ideas?

 

[Dimli]

Why not just select the print entire workbook option?
Or am I missing something?

 

[catrina616]

Its more the issue of duplicating the cells. I've already created the 3 sheet worksheet in which the 3 sheets are identical. I essentially want Excel to act like carbon paper -I want whatever I type in the cells on the first sheet to copy automatically to the second and third sheet so that what prints out is 3 copies of exactly the same thing.

Does that make any more sense? Its a template that will be used repeatedly, with different text and numbers added into the cells.

 

[Dimli]

Copy and past any relevant formats then use the formula =Sheet1!A1
for each cell that needs to be copied.

 

[catrina616]

That doesn't seem to work - when I try to use it, a window pops up entitled Update values: Sheet1.

I'm not using formulas in the cell. For example, in cell B7 I might type "Housing Project". I would want this to copy through to B7 in sheets 2 and 3. In cell B19 I might type a date. In cell C30 I could type a monetary amount. I would need all of these types of data to copy through to sheets 2 and 3.

Is this possible as far as you know?

Thanks.