There are 2 sheets - Summary and Report.
Report sheet contains a template.
After the summary is generated, staff works on it and a report is maintained in the template.
Since the volume of the report is huge, the work is allocated between the staffs by highlighting in colors.
Some notes are also maintained in columns S, T, U, V and W.
Macro should create an individual workbook from the template.
The newly created workbook should not contain any colors and notes.
This workbook and the worksheet should be named as Weekly_Report_20Apr
Since the name contains date, macro should name the workbook on dates when it is run.
Ex:
If it runs on 21 Apr macro should name the workbook and worksheet as Weekly_Report_21Apr
If it runs on 01 My macro should name the workbook and worksheet as Weekly_Report_01May
Note :
No changes should be done on the template, in other words the template should reflect colors and notes
whereas the individual workbook should not reflect colors and notes
Sample sheet attached, report sheet has some explanation
Bookmarks