Mcottuli
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!!
Would be happy to answer any more questions, or provide a template if needed. Thank you!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
macro-event.JPG
ASKER
Incredible work. Very impressive. Works like a charm!
If you send me the sheet I can add the necessary code and make sure that it works for you.