+ Reply to Thread
Results 1 to 1 of 1

Auto Sorting Column with Drop Down List in Cells

Hybrid View

  1. #1
    Registered User
    Join Date
    04-03-2011
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Auto Sorting Column with Drop Down List in Cells

    I have a Worksheet made of 4 Columns,120 rows, and headers in the first row. The fourth row is hidden and makes up the options for the drop down lists in each one of the cells in Column A. There are three options for the drop down lists that are text, and a fourth that is blank. I want to run a macro that will Alphanumerically Sort Columns A and B every time a value changes in Column A. Here's the kicker...values in A, B, and C have to stay paired next to each other. I have a Sort set up to do this, but can't record a macro that will run the sort every time a value is changed in Column A.
    Last edited by JayBag86; 04-03-2011 at 09:15 PM.

+ 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