I am looking for some VBA code that will add one to Column B when executed.
I also need this code to add one to column A when Column B is equal to 12 and
reset column B to 0. This SS contains years and months. However, I want to
execute this manually once a month.

Can someone help?

Example:

March 2009
Column A Column B
1 11

April 2009 After Macro Execution
Column W Column X
2 0

May 2009 After Macro Execution
Column W Column X
2 1

June 2009 After Macro Execution
Column W Column X
2 2


Thanks in advance.

C