Type once and the info goes into other cells

  • Thread starter Thread starter Pieflyer
  • Start date Start date
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,
 
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
 
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
 
Select all 5 worksheets. Press shift, click the leftmost sheet and then
click the rightmost sheet. Or press Ctrl and click on the individual sheets.
Enter the date in a cell on one of them, press enter. The date will be on
all 5 sheets. Then select the sheet you want to work on.
 
Back
Top