Dear all,
i have 2 sheets of data need to compare, if the data (sheet1) cannot find in (sheet2),
the row in sheet1 is deleted.
all my data is in number
Example:
sheet1:
columnB
1
2
4
5
7
6
Sheet2:
columnB
2
3
6
4
5
8
below is my coding i write, it take time to compare and delete, i have more than thousand data in both sheet:
any faster way to delete it? my coding take times to run...Please Login or Register to view this content.
Bookmarks