C
C
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
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