Hello all

This is probably easy for most of you, so I'll try and be brief. I a
totally stumped.

I have a spreadsheet. In sheet 2 COL A, I have a list of 20000
invoice numbers and only invoice numbers (one, 8 character invoic
number per cell). In column A of sheet 1, I have invoice numbers
spaces, and a little other data (raw text conversion) in rows.

I need to view in the invoice numbers from COL A sheet 1, that aren'
in COL A sheet 2. I tried doing an extended find and delete accordin
to COL A sheet 2 from a macro I wrote awhile back (to bold row
according to value) but it is far from working out.

In a nutshell: "Check sheet 2 COL A with sheet 1 COL A. If there ar
any matches, DELETE that row from sheet 1 COL A." Sheet 2 COL A i
just a checklist.

Thank you for reading.
Pa

--
Message posted from http://www.ExcelForum.com