Rolling 12 months and counting

[tkyon]

I'm trying to update a worksheet on a monthly basis where the worksheet will automatically delete the latest month and add the newest month. For example, the current worksheet contains data for jan 04 to dec-04....for the next update, i want the worksheet to add jan '05 and get rid of jan '04.....any thoughts?

Thanx

 

[just_jon]

To delete things, you'll need a VBA [ macro ] solution.

Give more details - how many rows, is it always keep the last 12 months, where the month designation is, etc.

 

[tkyon]

the worksheet looks something like the following.....

jan feb march....all the way to dec
a consumption new launch
b
c
d
e
f

the current sheet has data from jan 2004 to dec 2004.....but i want the update to include the jan 05's data and not jan 2004's data (but not deleting jan 2004)

thanks for the reply

 

[tkyon]

here is a better version of the worksheet

Jan-04 Feb-04 Mar-04 Apr-04 May-04
a exempt
b
c consumption
d no reason
e
f new prod.
g
h


hopefully this will help you to help me....

 

[just_jon]

So, you just want to keep the 12 right-most columns, should there be more than 12?