I have 2 sheets in same .xls file. In second sheet-column A, I have list of
some values, say 100 values. In sheet 1-column B, I have list of some 2000
values. Values of sheet 2-columnA are present in sheet1-columnB. Multiple
instances are also there. I want to find all these values in sheet1-columnB
AND OTHER ROWS OF SHEET1 (which doesn't contain values from sheet2) ARE TO BE
DELETED. How can we write macro for this?
Thank you in advance.
-Pawan