Hi all,
Not sure if this is feasible but I have a file with 3 columns (Name, Deal Name and Position), which is a driver connection and always refreshing. On a separate tab, which I called "Template" I need to create a drop-down for each of these. So first, I need a drop-down with the unique values in the Name column. Then, based on what name is selected, the drop-down of unique deal names associated with that name. And then depending on the Deal Name selected, the unique positions associated with that deal name. I'm uploading a sample file that shows my desired results in order to explain better.
Capturedrop-down.JPG
Bookmarks