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
|
|||
|
|||
Select rows and sort based on type
I have a spreadsheet that contains data for several different types of
accounts. I want to sort by sheet differently depending on the type of account (types are 1, 2, 3, and 4). The spreadsheet is currently sorted by account type. I want to sort further in the following way: if the account type is 1, I want to sort by account name. If the account type is 2, I want to sort by account number. If the account type is 3, sort by account number. If the account type is 4, sort by account name. I'm just guessing - but it seems like I should write a macro that will select all rows, for example, with "1" in the account type column and then sort the selected rows by the data in the account name column. Then, the macro should select all rows with "2" in the account type column and sort those rows by the data in the account number column. Etc. Is there a way to do this? Thanks! Sarah |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I sort (or group?) a spreadsheet by similar rows? | steve | Worksheet Functions | 3 | August 27th, 2005 06:33 PM |
Select rows, then sort | David | General Discussion | 2 | April 30th, 2005 04:36 AM |
How to sort by grouped rows | Mike | General Discussion | 2 | April 5th, 2005 10:51 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Sort forgets last sort and forgets I have header rows | medlint | General Discussion | 6 | June 19th, 2004 12:09 AM |