Hi All
Simply I want to copy data entered in workbook 1 to workbook 2, after it has printed sheet 1 of workbook 2 on Mondays clear the cells of information. I am stuck mostly with clearing on Mondays. partial help would be as welcomed as a complete solution.
In more depth:
Workbook "Master Report" has information occasionally added to sheets "4. Customer Complaints" (range B4:G4) and "5. Supplier Issues" (Range B4:F4).
So when this information is entered, to have that data transferred/ pasted (Concatenated) to Workbook "PPM Log" Sheet "KPI's".
information from the "Master Report", Sheet "4. Customer Complaints" should be pasted to range B122 (or the next available blank row) , and from sheet "5. Supplier Issues" pasted to range B145 (or the next available blank row).
Every Monday the PPM Log workbook, KPI's Sheet is printed, after that it then needs the ranges B122:B141 and B145:B160 cleared of data ready for the next week.
If needed, the date is recorded in workbook "Master Report", sheet "Report" in range K1.
All said so much easier than I can figure.
Simply I want to copy data entered in workbook 1 to workbook 2, after it has printed sheet 1 of workbook 2 on Mondays clear the cells of information. I am stuck mostly with clearing on Mondays. partial help would be as welcomed as a complete solution.
In more depth:
Workbook "Master Report" has information occasionally added to sheets "4. Customer Complaints" (range B4:G4) and "5. Supplier Issues" (Range B4:F4).
So when this information is entered, to have that data transferred/ pasted (Concatenated) to Workbook "PPM Log" Sheet "KPI's".
information from the "Master Report", Sheet "4. Customer Complaints" should be pasted to range B122 (or the next available blank row) , and from sheet "5. Supplier Issues" pasted to range B145 (or the next available blank row).
Every Monday the PPM Log workbook, KPI's Sheet is printed, after that it then needs the ranges B122:B141 and B145:B160 cleared of data ready for the next week.
If needed, the date is recorded in workbook "Master Report", sheet "Report" in range K1.
All said so much easier than I can figure.
