View Single Post
 
Old 09-30-2010, 05:21 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 Kimberly View Post
Why don't you select a cell in the Supplier column and click the Sort button? How would a macro improve on that?
Uh. Because it would automate it? One less step to have to do each time? Since it gets a whole heap of additions a day, it gets out of order quickly, so I want the macro to sort the spreadsheet by supplier upon opening/closing, so it's kept in order without me having to manually order it. Isn't this the point of macros?
Reply With Quote