Combo box that pulls specific data from range
 

Hi,
I have created a combo box that is uses an input range from another
workbook. I would like to pull a subset of this range into the combobox
based on a criteria (ex. If a Cell in range = "Active"), instead of the
entire list. Any Idea? Thanks