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