Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
Trying to decide weather to use a Pivot Table or Design a Macro for the
following. I have a ws that is set for filters on numerous columns. Unfortunately when I try to filter on certain release numbers, i.e. 1.2,1.2P1,1.2P3 is doesn't filter out all the others. Don't know if it is because of the P in the number or what. When I do a Pivot table I get all of the releases, however it seems easier to filter the releases easier this way. Any reason why the original ws won't do the same. I can design a macro, however I think I would have the same problem there. I thought of using an "Input" macro, however can't figure out how to pause to get the numbers of the first release before proceeding to the next release. Amy thoughts!!!!!!!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
What filter are you applying to the field? What is returned in the
filter, and what do you want returned in the filter? Beep Beep wrote: Trying to decide weather to use a Pivot Table or Design a Macro for the following. I have a ws that is set for filters on numerous columns. Unfortunately when I try to filter on certain release numbers, i.e. 1.2,1.2P1,1.2P3 is doesn't filter out all the others. Don't know if it is because of the P in the number or what. When I do a Pivot table I get all of the releases, however it seems easier to filter the releases easier this way. Any reason why the original ws won't do the same. I can design a macro, however I think I would have the same problem there. I thought of using an "Input" macro, however can't figure out how to pause to get the numbers of the first release before proceeding to the next release. Amy thoughts!!!!!!!!!! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |