+ Reply to Thread
Results 1 to 4 of 4

Code that will automatically alpha sort each sheet once activated

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    London, ON
    MS-Off Ver
    Excel 2007
    Posts
    43

    Code that will automatically alpha sort each sheet once activated

    Hello everyone
    I am hoping someone may be able to assist me. I have an Excel 2007 spreadsheet with two tabs; Master (sheet 1) and Closed (sheet 2). Currently there is scripting that will move an entire row from the Master sheet to the Closed sheet if the word "closed" is in column G. The Master tab auto sorts alphabetically once a new name is added and the sheet is activated however I cannot get the Closed tab to auto sort as well. I tried pasting the same coding in the window for Sheet 2 (closed tab) but that did not work. Does anyone know what I am doing wrong?
    I have attached a copy of the spreadsheet.
    Thanks for looking at this.
    Attached Files Attached Files
    Last edited by jingles9; 10-22-2015 at 01:14 PM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Code that will automatically alpha sort each sheet once activated

    Maybe Try the Workbook Sheet Activate instead. Seems to work for me.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-24-2013
    Location
    London, ON
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Code that will automatically alpha sort each sheet once activated

    Hi John
    I tried adding the above code and it still did not work for me. Upon further examination it was because the coding stated to start the sort at A5 instead of A2. Once I changed this it worked perfectly. Thanks for taking the time to review this

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Code that will automatically alpha sort each sheet once activated

    Glad to hear you've found a solution.

+ 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] Automatically sort table with VBA code
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2015, 11:03 PM
  2. Making this macro run automatically when the worksheet tab is activated
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 09:23 PM
  3. Using VBA Code to sort my data automatically
    By ssincerely in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2013, 02:12 PM
  4. Code to be activated when user Move or Copy a Sheet
    By batman07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2012, 09:33 AM
  5. Referenced sheet, automatically sort (alpha) and send blanks to the bottom.
    By jw586 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 10:48 AM
  6. data sort from alpha numeric sheet
    By b16dlg in forum Excel General
    Replies: 0
    Last Post: 06-09-2010, 08:52 AM
  7. way to automaitic sort sheet one numerical, sheet two alpha?
    By wichita6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 12:06 PM

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