| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a reference to a sheet that changes to todays date
Hi,
I have a formula that referst to a cell on particular sheet to get a result. That sheets name is todays date. I add a new sheet with the new date and I want my formula to change automatically to refer to the new sheet? Heres an example of the formula that I currently have to change manually? ='14 Aug 2006'!C8 Is that possible to make the formula dynamic? Any help is greatly appreciated as I have to do this every day. Thanks Sandra |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping a date when today's date changes | New Users to Excel | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
Threaded Mode
