capture filter values from a sheet into a dropdown list in use
Hey Dave, to make it clear. Here is and eg of how the data looks on sheet
Tasks Roll_No
3 11
5 11
4 12
6 12
2 13
5 13
3 14
4 14
1 15
2 15
1 16
4 16
So lets say you select "12" from Roll_No column filter
then it will display
Tasks Roll_No(filter)
4 12
6 12
So I want this 4 and 6 to be displayed in the dropdown list on userform too
Is there a way to capture filter values(4 and 6) from a sheet to a userfrom.
So when I input "12" on userform textbox I se 4 and 6 for my Tasks Dropdown
on the userform.
Hope I made it clear
Thanks in advance
"Dave Peterson" wrote:
Check your other post.
sam wrote:
Hi All,
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..
John: 1,3
Jill: 1,5
jack: 3,5,6
Bill: 2,4,6
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
"Tasks" column
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
--
Dave Peterson
|