Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is the situation:
I have 52 sheets each named by week, ie: May 5-May 11; May 12-May 18 etc. I have a cell in each sheet that references the beginning date of each sheet. Ie May 5; May 12 etc As I am preparing 52 sheets I would prefer not to have to fill in the date in each cell, in each sheet, or formulate by referencing the end date in the previos sheet and adding one. I would like to have a macro do it, but haven't much success so far. Of course I would have done manually by now for the time taken to figure this out. :( -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing dates | Excel Discussion (Misc queries) | |||
Modify a cell | Excel Discussion (Misc queries) | |||
Modify cell contents | Excel Discussion (Misc queries) | |||
Modify Cell Sizes | Excel Worksheet Functions | |||
Modify Cell sizes | Excel Worksheet Functions |