| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Auto change defined name ranges on Jan 1st annually
Hi there! I have the defined cell ranges below, all in the same sheet called Daily Tracking. I'm wondering if it's possible for these to be changed automatically as follows on 1st Jan each year?. CurYTD: Single cell Y375 to single cell Z375 in 2006 then AA375 in 2007 and so on, by 1 cell each year thereafter. PreYTD: Row from B375:X375 to B375:Y375 in 2006, then B375:Z375 in 2007 adding 1 cell to the range each year thereafter. Counter: Change the value in cell CG376 to 1. I really hope you can help me out here! -- MarathonMan ------------------------------------------------------------------------ MarathonMan's Profile: http://www.excelforum.com/member.php...o&userid=17729 View this thread: http://www.excelforum.com/showthread...hreadid=470057 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to change the blue colour of an activated Auto Filter button? | Excel Discussion (Misc queries) | |||
| Auto change font to 'capital letters' | Excel Worksheet Functions | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Auto color change to tabs in worksheet | Excel Worksheet Functions | |||
Linear Mode
