+ Reply to Thread
Results 1 to 3 of 3

Automatic sort on change in one column

  1. #1
    Registered User
    Join Date
    10-29-2018
    Location
    La Grange, Texas
    MS-Off Ver
    365
    Posts
    12

    Automatic sort on change in one column

    Hello, I have tried various VBA scripts from google searches and can't get them to work properly. Thank you in advance if you can help !

    I want to create a page in a workbook which has an address (street name) column (and some others) - that "Street Name" column will have data appended to it from other forms in the workbook. When that column gets a new entry, I would like it to automatically resort the page. The sort will be on Column "B" and I need data in all Columns to the left and to the right of column "B" to stay respective. Column "A" will have a street number, "B" Street name, C-J will have dates respective to the record associated with "A"/"B"

    Thanks for all your work !

  2. #2
    Forum Contributor
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003
    Posts
    155

    Re: Automatic sort on change in one column

    If column B is changed by a formula, you may need a Worksheet_Calculate event...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-29-2018
    Location
    La Grange, Texas
    MS-Off Ver
    365
    Posts
    12

    Re: Automatic sort on change in one column

    Thank you very much !!

+ 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. Auto Sort range by column value change
    By ngen33r in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-04-2018, 02:26 PM
  2. [SOLVED] VBA Auto Sort Table When Change Made to Column A by values in Column T
    By peterambart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2018, 12:17 PM
  3. Need Help - Automatic website navigation page change based on column data change
    By cbatten01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2015, 08:00 PM
  4. Change date automatic in an excel column
    By Dahlgren in forum Excel General
    Replies: 2
    Last Post: 04-22-2012, 11:05 PM
  5. Automatic Update of Sort Key Column in Excel VBA
    By makku in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2011, 04:56 AM
  6. Replies: 0
    Last Post: 11-02-2011, 12:21 PM
  7. [SOLVED] Automatic change color of searched value in a column...
    By MS Excel in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 07-06-2005, 08:27 AM

Tags for this Thread

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