Forum Discussion
Copy entire row to another sheet when either one of two criteria is met
It's my fault - sorry about that.
I used "NonComformitySchedule" in the code instead of "NonConformitySchedule". Please change this in the line Set wsh = Worksheets(...)
Should the row be copied to a fixed location (if so, which location), or to the first empty row on the other sheet, or ...?
Hi Hans, Firstly, thank you so much for your reply.
The data rows on source sheet "AuditChecklist" start at A10 and need to be copied to Rows starting at A10 on Recipient sheet "NonConformitySchedule".
The criteria column is H for either M or R entry.
**Note: column H will have several entries but im only interested in copying rows with either M or R entered into column H.
Hopefully the entire rows worth of data will be copied to the recipient sheet based on either M or R entry into column H.
I cannot thank you enough, I hope you can help
Richard