DataFilterAutofilter 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


On Sun, 28 Oct 2007 13:09:01 -0700, whatzzup
wrote:

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