M
MarathonMan
Hi there!
I have the defined cell ranges below, all in the same sheet calle
Daily Tracking.
I'm wondering if it's possible for these to be changed automatically a
follows on 1st Jan each year?.
CurYTD: Single cell Y375 to single cell Z375 in 2006 then AA375 in 200
and so on, by 1 cell each year thereafter.
PreYTD: Row from B375:X375 to B375:Y375 in 2006, then B375:Z375 in 200
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
I have the defined cell ranges below, all in the same sheet calle
Daily Tracking.
I'm wondering if it's possible for these to be changed automatically a
follows on 1st Jan each year?.
CurYTD: Single cell Y375 to single cell Z375 in 2006 then AA375 in 200
and so on, by 1 cell each year thereafter.
PreYTD: Row from B375:X375 to B375:Y375 in 2006, then B375:Z375 in 200
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