Quote:
Originally Posted by mellors
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
|
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.