Hi everyone,
I have two worksheets: ws1 and ws2
ws1.range("A1:Z1") all contain values
ws2.range("A1:Z20") all contain values
What I want to do is to check if ws2.range("A1:Z20") contains any rows that match all the values in ws1.range("A1:Z1"). So the match would be True if the values in the ws1 row match any of the rows in ws2.
Any ideas?
Thanks!!
Bookmarks