Increment Month by 1

Resolved · High Priority · Version 2003

Thu 23 Feb 2012, 13:57 Dav (guest) said...

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?

Tue 28 Feb 2012, 11:05 Trainer Paul said...

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

Tue 28 Feb 2012, 11:06 Trainer Paul said...

RE: Increment Month by 1

sorry, missed a bit, you can Hide column A when you have finished and before you stop recording.

cheers

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips