| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| producing a report via a keyword - filtering and macros not suitab | Excel Worksheet Functions | |||
| Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
| Data Filtering | Excel Worksheet Functions | |||
| filtering and macros | Excel Discussion (Misc queries) | |||
| filtering data | New Users to Excel | |||
![robert_woodie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
