Buttons for Macro Sorting
Posted by Christopher Manar on November 02, 2001 9:56 AM
I share a spreadsheet with two workers in other departments. Each of us accesses a large spreadsheet for different reasons, therefore we each want the data sorted a certain way for efficiency. I've never written a macro and what I want to do is program a button for each of 4 or 5 sort methods. For example, we track 3 separate order numbers, dates, Agent numbers, etc. Depending on the report we're reconciling, we want the workbook sorted a different way. Simple, but important.