If cells in Column of one sheet match those in same column of another sheet - delete row ?

[BPSJACK]

Hi,

I have an excel file with multiple sheets of references. What I'm after is a macro that would search through a list of references in column A of sheet 4, and if it finds the same references in Column A of sheet1 - then delete the entire rows its found in sheet1.

Does anyone know how I might go about this?

Any help you can provide would be very much appreciated

[stnkynts]

Please Login or Register  to view this content.

[BPSJACK]

That's brilliant thanks!

Is there any way to expand on this to search for matches over two columns. So if any adjacents cells in columns A&B in sheet4 match those in sheet1 then the row in sheet1 would be deleted. For example:

Sheet1	A	B	Sheet4	A	B
	123	001		123	002
	124	003		124	002
delete row	125	001		125	001

Is this at all possible?

[BPSJACK]

I think I've solved it. The following sub seems to do the trick.

Please Login or Register  to view this content.