Hey everyone,

I am building a template that consists of only 3 tabs.

One is the raw data tab, titled: Data
One is the list of products I have that feeds the Brand Input tab, titled: Primary Products
One is where I need help (marked in red), titled: Brand Input

I made a comment in the spreadsheet of what I am trying to do. Essentially, if you are in the "selection" column on the "Brand Input" tab, the user should see a list of all bathroom sinks from the data tab for example.

I am going to continue to update the data tab with additional bathroom sinks (example) and I am trying to find a way to quickly update the list once I add more information.

Is it as simple as using a Pivot Table and then just keep refreshing the data? How do I get them in a list format in a pivot table?

Longing for some help...

Thanks a lot.

Attached Files

Capex Selection Tool 07.06.15 CF.xlsm (213.8 KB, 11 views)