Type once and the info goes into other cells
 

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,

Type once and the info goes into other cells
 

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

Type once and the info goes into other cells
 

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

On Fri, 4 Jan 2008 21:45:02 -0800, Pieflyer
wrote:

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,

Type once and the info goes into other cells
 

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.

"Pieflyer" wrote in message
...
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,