Forum Discussion
Lavalips
Jun 22, 2021Copper Contributor
Copy entire row to another sheet when either one of two criteria is met
hi there, my boss has asked me to write a vba to copy and entire row from one excel sheet to another when she either puts either an M or an R into column H and im really struggling 😞 can you help?
- Jun 22, 2021
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(...)
Lavalips
Jun 22, 2021Copper Contributor
HI Hans,
Thank you for this, please find attached the workbook.
kindest regards
Richard
HansVogelaar
Jun 22, 2021MVP
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(...)
- LavalipsJun 22, 2021Copper ContributorHans my friend, I owe you a pint!
Can not express to you how grateful I am and indeed how much you have helped me today.
Blessings on you, your family and your friends.
I product design, design marketing campaigns and branding.
If there is anything I can ever do for you, please message me anytime.
Heel erg bedankt, mijn vriend
Richard