Need to find a solution that will aggregate the bolded data rows, after row 6, minus the Headers, and move them to a Report Template(.xlsm).
1. The Sheet Names of one, should be copied to the the sheet name of the report template.
2. The Sheet Name "Error Items
," of the actual report, do not have to be copied.
3. The column widths, within the Daily Report Template, need to stay as they are set.
4. The starting location can be either row 4 or 5, as the Headers will be copied to several locations within a Word.doc.
5. The data within the Template can be deleted or replaced each time the macro is run, and the new data can start at either row 4 or 5.
6. Each Sheet, within the template, should be sorted (A-Z), with the main criteria, being the column with the yellow text.
7. "Total items:" does not need to be included.
8.The formatting should be White Background and Black (Automatic) Text, for uniformity.
9. The last tab, Posted Late [Date] PM
will be placed in the Posted Late worksheet.
Attached is an example of a report, and the Daily Report Template.