Populate Combobox with Pivot Table Data
 

Hi All. I have been looking through old posts, but haven't been able to
find the right code.

I am trying to populate a combobox on one sheet with data from a pivot
table. Basically, I want the user to be able to make selections,
without having to filter through the pivot table.

Example:

Pivot Data:

Page Field is Ticker
Row Fields are Description and Name

I want the user of the combo box to select ticker. Then applicable
Descriptions come up. After selecting Description, Name selections
appear in combobox...

Does that make sense?

Thanks,

Scott