Is it possible to set the date only once for the complete workbook? I have
12 pages.
Thank you.
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)
"ED" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to set the date only once for the complete workbook? I
have
> 12 pages.
> Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks