Thread: Macro for automatic sorting
View Single Post
 
Old 09-28-2010, 09:07 PM
Ziggy-R Ziggy-R is offline Windows XP Office 2003
Novice
  
Join Date: Sep 2010
Posts: 13
Ziggy-R is on a distinguished road
Default
Quote:
Originally Posted by icurf8now View Post
Can't you just make a macro with the sort by 'supplier' and just run the macro?
That's exactly what I want to do, but I don't know how. I've got virtually no experience with macros.

Edit: Actually, that's exactly what my code does now. It sorts the data alright when I manually run the macro, but doesn't do it when I set it to AutoOpen or AutoExit. Any ideas?
Last edited by Ziggy-R; 09-29-2010 at 01:48 AM.
Reply With Quote