same date and set up on complete workbook
 

Is it possible to set the date only once for the complete workbook? I have
12 pages.
Thank you.

same date and set up on complete workbook
 

Ed,
Not exactly sure what you mean. If you mean, insert it onto 12
different tabs/worksheets within a workbook and they're all in the same
cell (e.g. A1), you can select cell A1 in Sheet 1, and then shift click
on the final tab/worksheet. This will select cell A1 in all tabs. Press
Ctrl ; to insert the date and press Ctrl Enter to enter it onto all 12
cells spread across the sheets.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=533435

same date and set up on complete workbook
 

Ed,
Not exactly sure what you mean. If you mean, insert it onto 12
different tabs/worksheets within a workbook and they're all in the same
cell (e.g. A1), you can select cell A1 in Sheet 1, and then shift click
on the final tab/worksheet. This will select cell A1 in all tabs. Press
Ctrl ; to insert the date and press Ctrl Enter to enter it onto all 12
cells spread across the sheets.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=533435

same date and set up on complete workbook
 

Maybe on Sheet2 add this formula to A1

=Sheet1!A1

and then again on the other sheets

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ED" wrote in message
...
Is it possible to set the date only once for the complete workbook? I
have
12 pages.
Thank you.