I have been trying to solve this for days (boss is not to happy)
I have multiple sheets in a workbook, I currently use a multiple criteria look up from 1 sheet to delete entire rows from another sheet.
now i need to do much the same except i have to cut and paste.
Sheet 1 sheet 2 sheet 3
a b a a b
2 4700 4700 2 4700
1 22 4701 3 4798
5 5001 4702
3 4798 4703 delete above from sheet 1
7 2205 4704
4705
etc to 4799
here is the code im trying to use, it just wont copy paste and then delete!
End Subit seems so simple but im not an expert. Please help i am way past a deadline.
Thank you in advance!!
Kevinsnewmatrix
Bookmarks