+ Reply to Thread
Results 1 to 3 of 3

Keep rows intact while sorting

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Arlington, TX
    MS-Off Ver
    Excel 2010, 2003
    Posts
    1

    Keep rows intact while sorting

    My dilemma is my staff. My staff is excellent at screwing up my data while sorting info in columns. I would love to LOCK info within a row so when my staff sorts, the info within a row stays together. I need to make it dummy proof. New rows are added every day to this spreadsheet and re-sorted by name or date.
    I know how to highlight all the data and sort including all columns, but it only takes one mistake to make it a huge nightmare to figure out what note goes with each patient.

    Example:
    Patient Z 11/15/2012 Call Dr Wang about root canal
    Patient Y 11/25/2012 Extract 4 teeth

    The staff will sort the info to make the patient last names in alphabetical order and oops:

    Patient Y 11/15/2012 Call Dr Wang about root canal
    Patient Z 11/25/2012 Extract 4 teeth

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Keep rows intact while sorting

    1. Were I you, I would edit my post to delete sentences 1, 2 & 4: They are unhelpful(!)...
    2. Write two macros corresponding to each sort option and put them at the top of the sheet, freeze panes to always have row one at the top of the window.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Keep rows intact while sorting

    Format it as a table with a header row. The header row will have a drop down box with options to sort or filter. Rows will remain intact, and your users will not have to make a choice about "expand selection."

    If you need a step-by-step solution, let me know what version of Excel you're using.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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