Link to home
Start Free TrialLog in
Avatar of Mcottuli
McottuliFlag for United States of America

asked on

Need help building a macro that will help me automate a change on the first of the month

I have a two sheet workbook, simply put. There is a percentage of work done calculated on sheet1!C46. This is calculated from check marks in C1-C45, when part of a project is completed a check mark is placed raising the percentage in C46. On Sheet two there is simply a row (C3-Q3) with each month in the mmm-yy format. Right now Sheet2!C4 which is directly below the corresponding month (Sep-13) has "=sheet1!C46" and is perfect. What I need is, on the first of each month the value in the previous month must Freeze/Save, and the running percentage from sheet1:C46 needs to move one column to the right into the next months column.

Would be happy to answer any more questions, or provide a template if needed. Thank you!!
Avatar of ChloesDad
ChloesDad
Flag of United Kingdom of Great Britain and Northern Ireland image

The best way to do this would be by using a macro to update the value of C4-Q4. The macro can then be run when you click on one of the check boxes.

If you send me the sheet I can add the necessary code and make sure that it works for you.
ASKER CERTIFIED SOLUTION
Avatar of ChloesDad
ChloesDad
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Additionally as I noticed that I didn't mention it the post above that the macro can be assigned to a key stroke or triggered automatically by an event such as the changed event of a worksheet.
macro-event.JPG
Avatar of Mcottuli

ASKER

Incredible work. Very impressive. Works like a charm!