Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filter multiple workbooks from drop down list selection
I have got a report that i want users to be able to pick thier name on a summary sheet from a drop down list and the subsequent 5 sheets will be filtered on thier name.
Is this enough detail or do you need specific cell refs? Thanks Andy |
#2
|
|||
|
|||
Quote:
using equal to or using formula fetch all the required names into hidden area of summary report tab, use data validation to show it in the drop down. note: data validation drop down doesnt suite for multiple sheets. please refer attached sample sheet.
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list selection | Excel Discussion (Misc queries) | |||
Multiple selection drop down list | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Can I set up a multiple selection drop down list? | New Users to Excel | |||
validation list - filter based on selection | Excel Worksheet Functions |