Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting dates on multiple sheets
This little macro will setup all your sheets:
Sub sheetdater() For i = 2 To Sheets.Count Sheets(i).Range("A1").Formula = "=Sheet" & i - 1 & "!A1+1" Next End Sub -- Gary''s Student - gsnu200825 "ramona" wrote: 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!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting dates on multiple sheets
Thanks, Gary"s Student. It took me a little bit to figure out this macro
since I've not created one before, but this will do nicely. Thank you again for your time. "Gary''s Student" wrote: This little macro will setup all your sheets: Sub sheetdater() For i = 2 To Sheets.Count Sheets(i).Range("A1").Formula = "=Sheet" & i - 1 & "!A1+1" Next End Sub -- Gary''s Student - gsnu200825 "ramona" wrote: 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!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting dates on multiple sheets
If you experience any problems, update this post.
-- Gary''s Student - gsnu200825 "ramona" wrote: Thanks, Gary"s Student. It took me a little bit to figure out this macro since I've not created one before, but this will do nicely. Thank you again for your time. "Gary''s Student" wrote: This little macro will setup all your sheets: Sub sheetdater() For i = 2 To Sheets.Count Sheets(i).Range("A1").Formula = "=Sheet" & i - 1 & "!A1+1" Next End Sub -- Gary''s Student - gsnu200825 "ramona" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding values in sheets and putting them on a summery | Excel Worksheet Functions | |||
Changing dates on multiple sheets | New Users to Excel | |||
Excel keeps putting .xls] on my sheets and then I get an error | Excel Discussion (Misc queries) | |||
Please help w/ putting dates on x-axis with .XValues. | Charts and Charting in Excel | |||
putting dates next to entries | Setting up and Configuration of Excel |