+ Reply to Thread
Results 1 to 6 of 6

Stand alone sort function

  1. 03-10-2014, 04:38 AM #1
    4lowie
    4lowie is offline
    Forum Contributor
    Join Date
    12-08-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    117

    Stand alone sort function

    Hi all
    Is it possible to set up a stand alone sort function? I have a protected sheet that I want to be able to sort, I can sort in manually but I'd really like to set up an automated sort funtion. Possible or not??

    Thanks Dave
    Reply With QuoteRegister To Reply
  2. 03-10-2014, 04:41 AM #2
    TMS
    TMS is offline
    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
    48,017

    Re: Stand alone sort function

    What does this mean:

    I can sort in manually but I'd really like to set up an automated sort funtion.
    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

    Reply With QuoteRegister To Reply
  3. 03-10-2014, 04:45 AM #3
    4lowie
    4lowie is offline
    Forum Contributor
    Join Date
    12-08-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Stand alone sort function

    What I mean is that at the moment I have to select all the cells in a day based group then enter the sort criteria. 7 day groups in my sheet so I have to do this 7 times. I'd like the sort criteria saved somewhere so I can just select all the cells and apply the sort. I know lazy I hear you say, not really I just want to standardise the method so everyone in our office produces the same result..

    Thanks
    Reply With QuoteRegister To Reply
  4. 03-10-2014, 04:53 AM #4
    TMS
    TMS is offline
    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
    48,017

    Re: Stand alone sort function

    No, not lazy. Practical, sensible and economic with your time/resources.

    I think you'd need to record a macro to sort the selected data. Might even be able to automate the selection but we'd need to see a sample workbook with some typical data.
    Reply With QuoteRegister To Reply
  5. 03-10-2014, 05:04 AM #5
    4lowie
    4lowie is offline
    Forum Contributor
    Join Date
    12-08-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Stand alone sort function

    I can't record a macro because this sheet is protected and I don't have the password.. It's one supplied to us to use but we don't like the way it's sorted....
    Reply With QuoteRegister To Reply
  6. 03-10-2014, 02:41 PM #6
    FDibbins
    FDibbins is offline
    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
    53,047

    Re: Stand alone sort function

    What does the data look like? Can you add a new sheet or a new table, and maybe use =LARGE() or =SMALL()?
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If(iserror function not functioning, but Iserror, and formula stand-alone work fine.
    By cadojib in forum Excel General
    Replies: 1
    Last Post: 12-15-2011, 08:43 PM
  2. Let the gurus stand up please
    By abambam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2011, 12:54 PM
  3. Stand Alone program
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2007, 10:47 AM
  4. Sort by subtotal, make the subtotal stand out
    By CC_mfc in forum Excel General
    Replies: 12
    Last Post: 02-12-2007, 11:06 AM
  5. [SOLVED] Stand alone
    By Khalil Handal in forum Excel General
    Replies: 1
    Last Post: 03-08-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1