Need help for searching excel entries for multiple matching criteria and copying matched cells by VB

[Sumedhk1889]

Hi,

PFA the sample file.
It contains 3 tables
1) table 1 shows requirements based on criteria(subject hobby location grade)
2)table 2 shows availability
3) table 3 shows expected output.

Need help for developing a macro that will
1) read criteria in table 1 row by row
2) for each criterion apply filter on respective column of table 2
3) after applying all criteria =>the matching entries (ID no and Name ) should get copied against corresponding requirement row.
4)if there are multiple matching entries then rows should get added below respective requirement and names should be displayed in descending order of age.

Kindly Help me with the VBA code for the same.

Thanks in advance!

 

[Marc L]

Hi !

An easy way is to use an advanced filter
(directly from worksheet like in a code) …

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

 

[Sumedhk1889]

Hi !

An easy way is to use an advanced filter
(directly from worksheet like in a code) …

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

Thank you so much for the help mark!
Will it be able to produce the desired results as shown in table 3 for table 1 and table 2 each being 400 entries big?

 

[Marc L]

Yes if criterias columns respect logic according to source range …
​