Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sarah
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make the sort default to 'No header rows' DJT Excel Discussion (Misc queries) 1 August 30th 05 12:40 AM
How do I sort (or group?) a spreadsheet by similar rows? steve Excel Worksheet Functions 3 August 27th 05 07:33 PM
sort 2 or more rows of cells linked to one row of data Magdalena Excel Worksheet Functions 1 July 16th 05 10:43 PM
Select rows, then sort David Excel Discussion (Misc queries) 2 April 30th 05 05:36 AM
How to sort by grouped rows Mike Excel Discussion (Misc queries) 2 April 5th 05 11:51 PM


All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"