Hello,
There is one main difference between my workplace excel and home excel auto filter. At work i can drop down the auto filter and sort by ascending or descending. whereas on my home computer i can't. why is this, is it because at home i dont have microsoft office pro 2003 at home?
Thanks,
Seth
I believe AutoFilter was introduced in Excel 2003. You'll need that version or higher to utilize it.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I was able to use autofilter in the version I have of microsoft xp. The ascending and descending feature in the autofilter is what I am missing. Did that come out in the 2003 version?
What Version do you have at home? You can tell from the Help>About menu.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks