+ Reply to Thread
Results 1 to 6 of 6

Macro that can sort rows in multiple sheets

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    Macro that can sort rows in multiple sheets

    Sorting.xlsx

    Hello,
    I am trying to figure out how to make a macro that can sort some numbers from Largest to Smallest within a specific range on multiple sheets. The range is only within column D starting with cell D11: (until the data ends) on all the sheets in my workbook (the number of sheets may change with time) except for Sheets: "A", "B" and "C".

    In other words I want the sort to work on all sheets except the first 3 sheets which are named Sheet A, Sheet B, and Sheet C.

    I have attached a spreadsheet for an example of what I am saying.

    Thanks
    Last edited by glide2131; 01-31-2014 at 03:17 PM.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,860

    Re: Macro that can sort rows in multiple sheets

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    Re: Macro that can sort rows in multiple sheets

    Thankyou that works very well.
    I had one other question, that I just thought of. How would I change the code if I had data in say columns A:I but I still want to sort using Column D?
    Thanks

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,860

    Re: Macro that can sort rows in multiple sheets

    Change this line:
    Please Login or Register  to view this content.
    to this line:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    Re: Macro that can sort rows in multiple sheets

    Wonderful! Thank you.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,860

    Re: Macro that can sort rows in multiple sheets

    My pleasure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to count rows on multiple sheets and display in message box
    By Cupragsw in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2013, 09:54 AM
  2. Macro to insert rows in multiple sheets and copy formulas
    By syt0x in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2013, 11:06 AM
  3. [SOLVED] Macro to sort variable rows of data by a column in multiple sections
    By mannuhs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2013, 03:22 PM
  4. Replies: 0
    Last Post: 11-08-2012, 01:07 PM
  5. Using Macro to put rows in multiple sheets in ascending order
    By harjas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2012, 11:59 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