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
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