DarReNz
10-25-2005, 07:20 PM
Hi,
I have a column Stat that has a drop down list that contains values Pend, Wait etc in B25(Test Worksheet)
How do I search for those rows only and display in Out Worksheet when those values(eg. Pend) are chosen ?
If this is not clear, what I meant was instead of manually selecting the auto filter that I want on Out Worksheet, I wish to do it on another worksheet (Test) by using values in the drop down list that correspond to the auto filters.
I have thought of an idea but not sure if it can be done which is to link the auto filter values from Out Worksheet into a drop down list on Test Worksheet. Can you help ? Thanks
I have a column Stat that has a drop down list that contains values Pend, Wait etc in B25(Test Worksheet)
How do I search for those rows only and display in Out Worksheet when those values(eg. Pend) are chosen ?
If this is not clear, what I meant was instead of manually selecting the auto filter that I want on Out Worksheet, I wish to do it on another worksheet (Test) by using values in the drop down list that correspond to the auto filters.
I have thought of an idea but not sure if it can be done which is to link the auto filter values from Out Worksheet into a drop down list on Test Worksheet. Can you help ? Thanks