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?
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?