same date and set up on complete workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set the date only once for the complete workbook? I have
12 pages.
Thank you.
 
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
 
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
 
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)
 
Back
Top