Delete rows on one sheet based on multiple columns of another sheet (both sheets with merged columns)

[ellaregis]

Hi there,

I'm quite new in Excel macros and I'm trying to go through 5,000+ rows of an excel sheet named Results (RAW). It contains data from Columns A to E:
A - 1st condition (with merged columns)
B - 2nd condition (with merged columns)
C - disregard
D - 3rd condition (with merged columns)
E - raw results (contains excess)

I have another sheet named Industry + Business Need which has Columns A to C:
A - matches Results (RAW) sheet's 1st condition (with merged columns)
B - matches Results (RAW) sheet's 3rd condition (with merged columns)
C - actual results

I need Results (RAW) to contain actual results only. Since I'm going through 5,000 rows, I need a code that can automatically delete rows on Results (RAW) sheet if they don't match ALL the conditions on Industry + Business Need sheet. Can you please help create a macro that would work for me? Kindly note that the code needs to work on merged columns. Thank you!

 

[sergioMabres]

Hi Ella
What some ppl use to do in these case is:
- Create a formula in a free column in Industry + Business Need let us say D2 =A2&" - "&B2
- Copy to the end of the sheet
- Then create a formula in a free column in Results (RAW) let us say F2 =vlookup(A2&" - "&B2,'Industry + Business Need '!D:D,1,0)
- Copy to the end of the sheet
- Now you ca sort or filter by column F in sheet Results (RAW) and delete all rows with value #N/A in column F

I hope this helps
Cheers
SWergio