pascarella
New Member
- Joined
- Jun 5, 2017
- Messages
- 2
I am trying to create a spreadsheet that takes data from another spreadsheet and produces drop-down menus for each field (removing duplicates), while narrowing down our next selections based on using indirect(). What I originally did was follow tutorials like this. It works, but only for the first column, I am not able to use indirect based on the first columns selection.
Here is a screenshot example of the data I am working with. I want to be able to choose from column 1 in a drop-down (while removing duplicates) , then choose from column 2 based on my selection from column 1 (while removing duplicates), and so on with the rest of the columns.
Let me know if you need more clarification.
Thank you
Here is a screenshot example of the data I am working with. I want to be able to choose from column 1 in a drop-down (while removing duplicates) , then choose from column 2 based on my selection from column 1 (while removing duplicates), and so on with the rest of the columns.
Let me know if you need more clarification.
Thank you
