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