Enter name on 1st worksheet and have it auto. enter on all others

P

pattyh

I have a worksheet with several pages, I want users to put comsumer name on
first page and have it automatically entered to all following pages in the
same cells.
 
G

Gord Dibben

patty

What do you consider a "page" to be?

In Excel terms a page usually means a printed page.

This page can be one of many from a single worksheet or one of many from
multiple worksheets.

See help on "linking" and perhaps it will become clear on how to add data to a
cell and have it replicated to other cells at the same time.


Gord Dibben MS Excel MVP
 
K

Kassie

I think we may have a terminology problem here. If you have one worksheet,
which requires more than one page when printed, its easy. If you want to
print the same name on each page, then enter the name in say A1, and have row
1 repeat at the top of each page. To do that, click on File|Page Setup,
click on the sheet tab, and select row 1. If you have one workbook with
several sheets, its a different story.
 
P

pattyh

I have one report with several pages, each of which need to have the name
entered at the top of each page, wanted to save workers the trouble of
putting it in each time they come to the top of the next page.
 
G

Gord Dibben

patty

File>Page Setup>Sheet>Rows to repeat at top is probably your best best.


Gord

I have one report with several pages, each of which need to have the name
entered at the top of each page, wanted to save workers the trouble of
putting it in each time they come to the top of the next page.
Click to expand...

Gord Dibben MS Excel MVP
 
Top