+ Reply to Thread
Results 1 to 7 of 7

Automaticac sorting

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    houghton regis bedfordshire england
    MS-Off Ver
    Excel 2010 soon to be 2016
    Posts
    47

    Automaticac sorting

    Hi

    I have a spreadsheet and I need to sort a3 and b3 down to a14 and b14
    then d3 and e3 down to d14 and e14 is there a way of doing this automatically
    rather than doing a manual sort ?

    any help would really be appreciated

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Automaticac sorting

    (Hi there, I believe I have some family living in Houghten Regis, and I lived in Beds when I was a todler)

    You cannot make anything like that "just happen", you will need to use some VBA. However, this should is a simple (relatively) process, and you could probably record a macro (VBA) that will do this for you, and add a "button" on the sheet that will do teh sorting when you click it
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Automaticac sorting

    Hi Lloyd,

    If you sort A3 to A14, "A - Z"
    Then sort D3 to D14, "A - Z"
    Wouldn't this change the "order" in A3 to A14?

    Regards

    peterrc

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Automaticac sorting

    If you select the first range and sort it, then select the second range and sort it, ignoring any suggestions that Excel might make to extend the range, they will be sorted independently.

    But, nothing's automatic. You'd need VBA for that.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Registered User
    Join Date
    02-11-2014
    Location
    houghton regis bedfordshire england
    MS-Off Ver
    Excel 2010 soon to be 2016
    Posts
    47

    Re: Automaticac sorting

    HI FORD

    Can you give me some suggestions on the vba ?

  6. #6
    Registered User
    Join Date
    02-11-2014
    Location
    houghton regis bedfordshire england
    MS-Off Ver
    Excel 2010 soon to be 2016
    Posts
    47

    Re: Automaticac sorting

    hi trevor

    Would you be able to suggest some vba for me

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Automaticac sorting

    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 12-16-2015, 01:04 PM
  2. [SOLVED] I require sorting formula in excel sheet with complex sorting.
    By kaminanirav in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2015, 08:16 AM
  3. Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  4. Sorting by Date--Need help when sorting by 2-digit year
    By Farris_TN in forum Excel General
    Replies: 3
    Last Post: 06-20-2013, 11:20 AM
  5. Sorting 2 data ranges by comparing one column in each and sorting to match
    By MDKsmiffy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2013, 03:30 PM
  6. Sorting a range to invert it upside down without sorting by any specific column
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2013, 12:53 PM
  7. [SOLVED] Sorting a range to invert it upside down without sorting by any specific column
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 12:43 PM

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