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!