I want to capture filter values from sheet2 into a Dropdown list in the user
form. Is there a way to do this?
For eg, I have a column "Tasks" on sheet2 which have values 1,2,3,4,5,6 and
each student can have multiple "Tasks" such as..
and so on... I have this column set as a filter(Behaves like a dropdown on
excel sheet), so John will have a Dropdown Filter with values 1 and 3 in
So basically, I want these filter values to be displayed on the form as
dropdown menu with 1 and 3 displayed for John.
Hope I made it clear
Thanks in advance