Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default 2007 excel autofilter back to 2003 autofilter?

Is there anyway to get the 2003 autofilter functionality to work in excel 2007?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 2007 excel autofilter back to 2003 autofilter?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 2007 excel autofilter back to 2003 autofilter?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default 2007 excel autofilter back to 2003 autofilter?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible Autofilter Bug (2003 and 2007) Barb Reinhardt Excel Discussion (Misc queries) 5 December 19th 09 02:07 PM
Autofilter in 2007 limits view in 2003 RFP330 Excel Worksheet Functions 4 October 25th 08 02:17 PM
Excel 2007 Autofilter vs Excel 2003 James8309 Excel Worksheet Functions 2 July 24th 08 03:52 AM
2007 Autofilter worse than 2003 Autofilter jsky Excel Discussion (Misc queries) 9 October 31st 07 12:14 AM
Excel 2003: Autofilter oceanmist Excel Discussion (Misc queries) 1 September 21st 06 08:39 PM


All times are GMT +1. The time now is 03:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"