Filtering data within macros
 

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

--
Message posted from http://www.ExcelForum.com

Filtering data within macros
 

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