Populate Combo box 2 based on Selected item in Combo box 1

Hello everyone,

I am new to Excel Macros.

I have a problem in populating 2 combo boxes in my excel sheet, where in the later one is dependent on the first combo box.

The source for these 2 combo boxes exists in another workbook in the same sheet.
The sample data is as below

Folder Name Workflow Name
AUDIT wkf_eval_update
AUDIT wkf_eval_cf_update
AUDIT wkf_eval_correct
EPG wkf_epg_aud_tmplt
EPG wkf_epg_audit

I have created two dynamic named ranges namely FolderName (refers to B column which has lot of duplicates) and WorkflowName(refers to C column).

For the first combobox, the dynamic named range FolderName is the source. So combobox 1 is populated with 2 values AUDIT, EPG.
Here, my intention is "when i select AUDIT from combobox 1, then combobox 2 should be populated with the 3 values which corresponds AUDIT in the source worksheet.

Can someone help me with the code / tutorial for resolving this problem?

Thanks a bunch.