Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Automatic Sorting - Alphabetically

  1. #11
    New Member
    Join Date
    Apr 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you kindly for all of your help Derek, I appreciate it.

    I hope all is well in Australia.

    Sean

  2. #12
    New Member
    Join Date
    Jul 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automatic Sorting - Alphabetically

    Quote Originally Posted by Al Chara View Post
    You can use VBA. Try the following code in the code for your worksheet:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Target.EntireColumn.Sort Key1:=Target, Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    End Sub



    I tried using this code but it moved my data (List of names) up to the first row. If i have my data starting from B10 up to B45, I want my data to remain at B10 downward. I also want to expand selection to the next column.


    thanks,

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •