Macro needed: list results based on criteria

Hi,

I have a list of companies with the countries they have branches. On a separate sheet is a list of holidays per country.

I need your help in coding a macro that will create a list of all the holidays available for each company. Attached is a workbook as reference with an expected results tab.

Would appreciate any help. ThanksCompany Holidays.xls

nantoy,

Welcome to the forum!
Give this a try:

Please Login or Register  to view this content.