Results 1 to 8 of 8

update Sort Macro

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    oxfordshire
    MS-Off Ver
    Excel 2003
    Posts
    72

    update Sort Macro

    I'd like to update a sort macro (I know knowing about macros) on a spread sheet I've inherited.

    The info in cells A3:E60 are sorted by this macro, but I would also like info in cells AA3:AB60 and AD3:AN60 sorted along with A3:A60 when the macro is ran.

    Sheets(" MON").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers
    Sheets(" TUE").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers
    Sheets(" WED").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers
    Sheets(" THUR").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers
    Sheets(" FRI").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers
    Sheets(" SAT").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers
    Sheets(" SUN").Select
    Selection.sort Key1:=Range("E60"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortTextAsNumbers



    Can anyone help with this please :-)
    Last edited by summer2010; 09-16-2013 at 05:23 AM. Reason: changes

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stop update formulas when macro starts then update when complete
    By ruperupe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2012, 02:42 PM
  2. Excel 2007 : How to automatically sort upon update.
    By mom2dramaqueen in forum Excel General
    Replies: 1
    Last Post: 07-18-2011, 03:09 PM
  3. Custom Sort Macro - Update on Data Entry
    By cuso524 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2010, 01:38 PM
  4. sort table after data update
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2009, 09:48 AM
  5. Update and Sort
    By Unregistered1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2005, 11:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1