My understanding of your explanation and sample code is:-
- You have numeric values in Column C of a worksheet named "WIP Schedule".
- In the "WIP Schedule" sheet, if any cell in Column C has a value greater than 0 (zero), then cells from Columns E, F and H on the same row need to be copied to cells C3, C6 and D1 respectively in a worksheet named "Regular".
- Immediately after the relevant cell data has been transferred to the "Regular" sheet, the data on the "Regular" sheet, with the newly transferred data from the "WIP Schedule" sheet, needs to be printed out.
- I'm assuming that you have headings in Row2 in the "WIP Schedule" sheet with data starting in Row3.
- With this line of code:-
I'm assuming that you are calling another macro to do the printing.
Is my understanding correct?
It would also be very helpful for potential helpers if you uploaded a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then posted the link to your sample file back here.
Make sure that your sample is an exact replica of your workbook showing actual inputs and the expected outputs. If your data is sensitive, then please use dummy data. A dozen or so rows of data will suffice for us to work with.
Please ensure that any code that you already have is included in the sample.