LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default putting dates on multiple sheets

We are using Excel 2003. I have a workbook for each month so that each sheet
is a different day. These sheets need to be dated. I know that I can enter
the following formula on each sheet so that only the first sheet needs to be
manually dated. For Sheet2 =Sheet1!A1+1; for Sheet3 =Sheet1!A1+2 OR
=Sheet2!A1+1; etc. Is there some way this can be done without having to go
back to each previous sheet or keying in this entire formula? I guess I'm
looking for a simple copy that won't make me have to go back to previous
sheets. I know we will only have to make one workbook (template) but there
will be other times this could be very handy.

Thanks in advance. I love this site!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding values in sheets and putting them on a summery Garry55 Excel Worksheet Functions 2 October 1st 08 03:08 AM
Changing dates on multiple sheets andyco11 New Users to Excel 3 March 1st 07 07:11 PM
Excel keeps putting .xls] on my sheets and then I get an error Michelle Excel Discussion (Misc queries) 1 August 2nd 06 12:38 PM
Please help w/ putting dates on x-axis with .XValues. Lee Holsenbeck Charts and Charting in Excel 1 January 27th 06 04:14 AM
putting dates next to entries peter Setting up and Configuration of Excel 6 October 23rd 05 06:43 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"