Type once and the info goes into other cells

P

Pieflyer

I'm making a 5 page doc that will be used 2 times a week. I need to put the
date on each page and would like to type it once on the first page and then
have it go onto each page in the same place. Thanks,
 
C

Carim

Hi,

If you type your date in the first page in cell A1 ...

Go to your second page, to the cell where you need the same date to
appear:
1. Type =
2. With your mouse, go back to your first page
3. Go to the original cell A1
4. Hit Enter

HTH
 
G

Gord Dibben

A few ground rules to set first.

What do you consider as a "doc"? An Excel workbook or?

What do you consider as a "page"? A worksheet within a workbook or?

If 5 worksheets within a workbook I would suggest that you check out help on
linking cells from one sheet to another.

=Sheet1!A1

entered in a cell in each of the sheets will return whatever you type into A1 of
Sheet1


Gord Dibben MS Excel MVP
 
Top