Copy & Pasted - Print then Clear on Weekday

dnorm

Board Regular
Joined
Dec 28, 2017
Messages
79
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.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,099,083
Messages
5,466,538
Members
406,485
Latest member
kaksolver

This Week's Hot Topics

Top