PDA

View Full Version : [SOLVED] Compare sheets macro



blackie42
10-06-2014, 02:49 AM
Hi,

I wonder if someone could help please, macro or Vlookup?

I have 2 sheets in workbook, sheet 1 has around 100,000 entries and sheet 2 has 89,000.

I need to delete any entries (the whole row) from sheet 1 that are in sheet 2 using column A as the reference (which is the unique client ID)

Any help appreciated

many thanks
Jon

blackie42
10-06-2014, 02:54 AM
Apologies I didn't think I'd posted the ealier thread - so this is the same as 1st

Aussiebear
10-06-2014, 02:59 AM
No problemo Blackie42. I shall invite 13 darleks to exterminate the thread