Results 1 to 6 of 6

Auto sort alphabetically using basic macro

Threaded View

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Oakland, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Smile Auto sort alphabetically using basic macro

    Hello,
    I have scoured this and other excel forums looking for a simple macro code I can drop into my excel document to auto sort alphabetically based on a column, but have been unsuccessful. I have attached my worksheet to provide context to my question.

    All I need is a macro that auto sorts all the rows alphabetically (descending) based on column C ("General Topic Categories") on sheet 1. Ideally the auto sort would occur once all the data in a row has been entered (i.e. column L), but I would be fine if it auto sorted after data was entered in column C in sheet 1. Also note that this will be be growing document, so the number of rows will always be increasing. It should be obvious but I don't want the headers sorted, so the first cell that should be alphabetized will be C2

    I know this can easily be done using the sort function, but I will not the one imputing the data and the individual in charge would like it auto sorted.

    Thank you in advance for your help

    Attached Files Attached Files

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