+ Reply to Thread
Results 1 to 2 of 2

Automatically Sorting a Data Range any time a change is made

Hybrid View

  1. #1
    Registered User
    Join Date
    10-22-2015
    Location
    Dallas
    MS-Off Ver
    2010/2013
    Posts
    2

    Automatically Sorting a Data Range any time a change is made

    So I'm trying to build a spell list for a table top game that I can quickly and easily find the information I need on my phone while we're sitting at the table.

    I have 5 columns of information
    Prep? Lvl Name Effect
    FALSE Unchecked Box 1 Calm Animals Spell Description
    TRUE Checked Box 3 Remove Curse Spell Description

    Just as a quick sample. Off to the right in columns K and L I have other information that ties into Concatenated formulas throughout the sheet, so I DO NOT want this information to move. So here's what I need, and I can't for the life of me figure it out;

    Based on whether Column A is TRUE or FALSE (I.e. Whether the checkbox in the Prepared? column is Checked or Unchecked) I need the data in A2 through E87 to automatically sort every time a change is made in column A. It needs to be any change, because I'm not adding or removing any data from this spreadsheet. Whenever the data in column A changes I need it to sort all TRUE cells to the top of the list. Ideally I'd like this to only function on Sheet 1, as I have other information on Sheet 2 that doesn't need to be sorted. But if it doesn't work like that then I'll deal.

    What else I'd like, if this is possible but it is much less important overall, is for it to automatically further refine the sorting. I.E. Spells are first sorted by True or False, then sorted by the level in Column C, and then finally sorted Alphabetically by the name listed in Column D. That's probably a little complex, and since I don't use Excel all that often I don't even begin to know if this is possible, but his seems like the place to ask.

    Thank you so much for your help in advance!

  2. #2
    Registered User
    Join Date
    10-22-2015
    Location
    Dallas
    MS-Off Ver
    2010/2013
    Posts
    2

    Re: Automatically Sorting a Data Range any time a change is made

    Too complicated?

+ 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. Incrementing Column's value +1 each time a change is made in another worksheet
    By SuGo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2013, 12:16 PM
  2. Change the line graph range in Excel 2007 automatically without changing the data range
    By vinuhm@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 05:26 AM
  3. Auto Date when a change is made within a range of cells
    By arangel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 05:23 PM
  4. Replies: 2
    Last Post: 11-27-2012, 05:55 AM
  5. Replies: 2
    Last Post: 11-16-2012, 01:44 PM
  6. Replies: 7
    Last Post: 06-24-2012, 04:22 AM
  7. Excel 2007 : Range made automatically
    By freehawk in forum Excel General
    Replies: 1
    Last Post: 04-05-2010, 01:37 PM
  8. [SOLVED] individually time stamp a row when a change is made to that row
    By chuck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-27-2006, 02:10 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