same date and set up on complete workbook

[ED]

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

 

[Clivey_UK]

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]

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

 

[Bob Phillips]

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)