PDA

View Full Version : Solved: Form & Filter



khalid79m
10-23-2008, 01:59 AM
:banghead: 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
03-19-2009, 09:20 AM
Ken has a file here
http://www.mrexcel.com/forum/showthread.php?t=354580
that should get you started on the right path.

khalid79m
03-24-2009, 04:57 AM
Thanks , really appreciate the help