Dates and columns

[erodri02]

This is the layout:

12/03-------------Months in between-------------------->11/04

Now once the month of December is over and January comes in my row no
reads:
01/04-------------Months in between--------------------->12/04

As a month comes to an end it drops and the current new month shift
over and it adds a following month at the end. So it will always hav
an updated 12 month look. Now under every month there is dat
associated with it. What I want to do is capture the current month an
the data associated with it and save it on another worksheet. And a
the new months come in I want to do the same for them. Please pleas
help on this concern. Thank you

 

[Dave Peterson]

Can't you just select that column, cut it, paste it to the other worksheet, then
go back and delete that column. And insert a new column to the far right?

If you needed a macro, you could record one when you do it once manually.

Since everything is shifting over to the left, it should work with little
modification (but post back if you need help).

But I don't think I'd do this. By separating your data into different
worksheets, it makes it more difficult to do things against all of
it--charts/sorts/pivottables (summaries).

I think I'd just hide that first column and insert a new one--or have all the
columns there and only show 12 at at time.