+ Reply to Thread
Results 1 to 4 of 4

Auto sort By Row

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    Everett Wa
    MS-Off Ver
    2016
    Posts
    3

    Auto sort By Row

    Need to know if it is possible to right a formula that would auto sort in abc order column 1 but move all the data in the row with it.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: Auto sort By Row

    You could do this in a separate table using the first one as data source. But why not just use AutoSort?

    Select all the data in the table and with the sort field (column A ?) the active cell click Data and then click Sort. When the field sorts it will carry each record (row) with it.
    Dave

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    Everett Wa
    MS-Off Ver
    2016
    Posts
    3

    Re: Auto sort By Row

    That worked great. TY

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: Auto sort By Row

    You're welcome.

+ 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. [SOLVED] Auto-Sort or Auto-Filter
    By Brennen81 in forum Excel General
    Replies: 1
    Last Post: 07-19-2015, 08:44 PM
  2. VBA in change event format to auto remove rows having zero value and auto sort
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-06-2013, 09:18 AM
  3. Auto Sort or Auto Filter?
    By vmathews08 in forum Excel General
    Replies: 2
    Last Post: 02-11-2013, 02:21 AM
  4. Need help- Auto Sort data and auto subtotal
    By lesliewheeler in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-28-2013, 07:11 AM
  5. Auto sort and auto group
    By bobhov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2012, 12:37 AM
  6. Auto Sort, Auto Lock, Auto Date & Time Stamp
    By suehatesyou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2010, 02:57 PM
  7. Can I "auto-sort" or use a quick button to sort?
    By drewkloc71 in forum Excel General
    Replies: 4
    Last Post: 09-07-2009, 03:14 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