Macro to extract data based on match from other sheet

[IKHAN]

Hello,

Require - Macro to extract data based on match first and last name

4. mobile(Column D and Column E)
row starting from 18

Match Column A and Column B (8.contacts sheet)


and extract\copy data based on match to

4. Mobile sheet

row starting from 18

Fill Column A (4. mobile) extracting data from (8.contacts) Column C
Fill Column C (4. mobile) extracting data from (8.contacts) ColumnD
Fill Column F (4. mobile) extracting data from (8.contacts) column E
Fill Column G (4. mobile) extracting data from (8.contacts) column F
Fill Column H (4. mobile) extracting data from (8.contacts) column H


If no match found - should fill ROW with "DNE" in (4.mobile)

Uploaded sample file

 

[Marc L]

Hi !

Try advanced filter, easy !

• Introduction to Excel Advanced Filters
• Extract data using Advanced Filter and VBA
​