Filtering data within macros

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

I have a spread sheet with 6 coloums of data such as name,month,job.
have filters so i can see how many jobs are done in a month or how man
jobs one person is doing. I would like to be able to write a macr
which works out most of the combinations of filters and outputs it to
seperate sheet. There are lots of different options for each coloum
tho! Is there any quick ways i can do this other than reseting th
filters everytime for every combination?

hope i have explained this ok....its even confusing me!!

Cheers
Robert
 
Hi Scott,

Sounds like a job for a pivot table and then issue the show page command. The show page command will create a sheet with each job on it.

I hope that helps.

Jim
 
Back
Top