If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting a column in a spreadsheet
What is the best way to sort a spreadsheet? My boss wanted filters set up,
so I set up an autofilter for all columns. She also wanted to sort by one column, so I recorded a macro that sorted the column in ascending order and another macro to sort it into descending order. I thought there might be a better way to do it. Also, can I assign the macro to a button instead of a shortcut key? Thanks for the help!! Ken -- akkrug |
#2
|
|||
|
|||
Sorting a column in a spreadsheet
If you've setup your autofilters correctly, you can simply use the sorting
capability listed within the filter. But yes, you could create a button from the forms toolbar (or a picture, if you like) and assign a macro to either of them. -- Best Regards, Luke M "akkrug" wrote in message ... What is the best way to sort a spreadsheet? My boss wanted filters set up, so I set up an autofilter for all columns. She also wanted to sort by one column, so I recorded a macro that sorted the column in ascending order and another macro to sort it into descending order. I thought there might be a better way to do it. Also, can I assign the macro to a button instead of a shortcut key? Thanks for the help!! Ken -- akkrug |
#3
|
|||
|
|||
Sorting a column in a spreadsheet
akkrug wrote:
What is the best way to sort a spreadsheet? My boss wanted filters set up, so I set up an autofilter for all columns. She also wanted to sort by one column, so I recorded a macro that sorted the column in ascending order and another macro to sort it into descending order. I thought there might be a better way to do it. Also, can I assign the macro to a button instead of a shortcut key? Thanks for the help!! Ken I know bosses expect to have the info at their finger tips but I think this is a case of teach a man to fish. The functions you are asking about sort and filter are two basic functions in a spreadsheet. take 2 minutes and show this person HOW to do this themsleves and save yourself some time. gls858 |
Thread Tools | |
Display Modes | |
|
|