Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) | |||
How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
Select rows, then sort | Excel Discussion (Misc queries) | |||
How to sort by grouped rows | Excel Discussion (Misc queries) |