PC Review


Reply
Thread Tools Rate Thread

how do i keep sort settings?

 
 
MsMcGyver@msn.com
Guest
Posts: n/a
 
      28th Jul 2008
I have a spreadsheet that is not really used as one. It is a tally of 120
different categories so with in the spread sheet I am sorting by number of
votes say column b and then add field and the balance of a gets sorted
alphabetically. the sort box cles each section and i have to re set the
settings. can i keep it open and default the settings for this project? I am
new to 2007 excel
Thanks

 
Reply With Quote
 
 
 
 
RyanH
Guest
Posts: n/a
 
      28th Jul 2008
I would setup a Custom ToolBar Button and assign this macro to it. This way
whenever you click this button it will sort the columns specified. Note:
The code below sorts Columns A then B then C, you will have to change it to
accomendate your application.

Hope this helps!
--
Cheers,
Ryan


"(E-Mail Removed)" wrote:

> I have a spreadsheet that is not really used as one. It is a tally of 120
> different categories so with in the spread sheet I am sorting by number of
> votes say column b and then add field and the balance of a gets sorted
> alphabetically. the sort box cles each section and i have to re set the
> settings. can i keep it open and default the settings for this project? I am
> new to 2007 excel
> Thanks
>

 
Reply With Quote
 
MsMcGyver@msn.com
Guest
Posts: n/a
 
      28th Jul 2008

Thanks Ryan I don't see the macro?
Shuree
 
Reply With Quote
 
RyanH
Guest
Posts: n/a
 
      28th Jul 2008
Oops! This is better. I assume you have a header row, if not, just delete
the Header portion of the code


Sub SortData()

ActiveSheet.UsedRange.Sort Key1:=Range("A2"), Order1:=xlAscending, _
Key2:=Range("B2"), Order2:=xlAscending, _
Key3:=Range("C2"), Order3:=xlAscending, _
Header:=xlYes

End Sub
--
Cheers,
Ryan


"(E-Mail Removed)" wrote:

>
> Thanks Ryan I don't see the macro?
> Shuree

 
Reply With Quote
 
MsMcGyver@msn.com
Guest
Posts: n/a
 
      28th Jul 2008
You Rock! In a former life i knew about macros. Apparently I forgot. Duh!
Thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Sort settings Old_Jim Microsoft Excel Misc 1 1st Nov 2009 02:41 PM
get current sort settings JString Microsoft Access Form Coding 1 7th Aug 2008 11:06 PM
how do i save the sort settings =?Utf-8?B?bGFyazRkcg==?= Microsoft Excel Setup 0 8th Jun 2007 10:47 PM
Keep sort settings in Excel =?Utf-8?B?ZGFuaWVsY3dn?= Microsoft Excel Worksheet Functions 0 12th Feb 2006 09:26 PM
Saving Sort Settings =?Utf-8?B?dWNmY2hpY2s=?= Microsoft Excel Misc 2 10th Feb 2006 03:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:23 AM.