Solved: Form & Filter

[khalid79m]

My Data

I have an excel workbook, which currently has 2 sheets. The first sheet is labelled Data, this contains the following columns SITE,NAME,TEAM,MANAGER this is my source data. the 2nd sheet is a graph linked to this source data. When I apply a filter to the source data the graph changes. Which is exactly what I want to do.

The only change I want to make is to input somesort of form so the user can filter by site, then team manager then team then name. I dont want them to show them the enitre source data

Can you help?

[slurpee55]

Ken has a file here
http://www.mrexcel.com/forum/showthread.php?t=354580
that should get you started on the right path.

[khalid79m]

Thanks , really appreciate the help