Dear Experts,
I need help to create automatically copy and create sheet with new next week with data from previous week except "Support Category" and sheet rename as per Sheet Weekly_summary A column each week automatically when we click create new week button.
I have put some code in Generate summary but i m not able to pull the data on weekly basis.
This sheets needs to create till December 2016.
Whatever the changes happening in previous weeks in Column "C, F, G & O" of all weeks its copy and paste to Data changes sheet. Sample format attached.
Monthly and quarterly summary i have put some formulas to pulled the data from weekly summary.
Kindly help me this i m doing weekly and creating new sheet each time entire year and putting formulas.
Let me know if any more information required.
Regards
Prasanna
I need help to create automatically copy and create sheet with new next week with data from previous week except "Support Category" and sheet rename as per Sheet Weekly_summary A column each week automatically when we click create new week button.
I have put some code in Generate summary but i m not able to pull the data on weekly basis.
This sheets needs to create till December 2016.
Whatever the changes happening in previous weeks in Column "C, F, G & O" of all weeks its copy and paste to Data changes sheet. Sample format attached.
Monthly and quarterly summary i have put some formulas to pulled the data from weekly summary.
Kindly help me this i m doing weekly and creating new sheet each time entire year and putting formulas.
Let me know if any more information required.
Regards
Prasanna