Increment Month by 1
I have a 6 month forecast in a spreadsheet. The top of each column (A-F) has the name of a month e.g. Jan Feb Mar Apr May Jun.
I want to introduce a macro which when run will automatically increment each of the months by 1 so in column A "Jan" will become "Feb". In column B, "Feb" will become "Mar" etc...
How can I achieve this?
RE: Increment Month by 1
Record the macro and do the following;
>insert a column to the left of A.
>in A1 enter the formula =B1 (which is the first month on your list)
>copy A1 and paste it back into A1 as a Value only
>auto fill from A1 to G1
>stop recording
then create your button, attached the macro and away you go.
Hope that helps.
Cheers
Paul
RE: Increment Month by 1
sorry, missed a bit, you can Hide column A when you have finished and before you stop recording.
cheers
