Drop down menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good evening, i have created a dropdown with project names but what i want to
do is once i have selected say Project "A" the worksheet would contain only
cells relating to that specific project. I would have a worksheet with all
the other project and data but once a select a project only project specific
info is required. Is there a way of doing or a sample that can be supplied?
Thanks
 
Data>Filter>Autofilter would work for you and it already has a dropdown list.

If you wanted to use your own dropdown list you would have to add VBA code to
achieve the same thing.


Gord Dibben MS Excel MVP
 
Back
Top