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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prefilled Outlook Yes Voting Button response 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Help with macro 2
VBA to Assign Outlook Task 2
Link to file using data from another file in link to 4
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Count Days until Completion 1
Vlookup-Wrong Sheet! 9

Back
Top