Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there anyway to get the 2003 autofilter functionality to work in excel 2007?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What part of it doesn't work?
jonnybrovo815 wrote: Is there anyway to get the 2003 autofilter functionality to work in excel 2007? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I see you have a response to one of your other posts -- in a different forum.
Dave Peterson wrote: What part of it doesn't work? jonnybrovo815 wrote: Is there anyway to get the 2003 autofilter functionality to work in excel 2007? -- Dave Peterson -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry about all the dups, I was having problems posting and thought they were
not posting....so now I see all are posted. Face is red. The reason I ask is because I do a lot of manual validation of records based upon a value in a column. I check all values in other columns based upon the filtered value. So basically what I did in excel 2003 is click autofilter and down arrow to the first value. I then check all records that filter out and validate they have the same info or different based upon the filtered value. Then I click the autofilter arrow and down arrow to the next value and click the enter key to filter to the next value, so on and so forth. It works very fast. the new version you have to unselect all then select the value and then unselect the value and then select the next value. Not very fast. "Dave Peterson" wrote: What part of it doesn't work? jonnybrovo815 wrote: Is there anyway to get the 2003 autofilter functionality to work in excel 2007? -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possible Autofilter Bug (2003 and 2007) | Excel Discussion (Misc queries) | |||
Autofilter in 2007 limits view in 2003 | Excel Worksheet Functions | |||
Excel 2007 Autofilter vs Excel 2003 | Excel Worksheet Functions | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
Excel 2003: Autofilter | Excel Discussion (Misc queries) |