• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

put records in order

A

ahhhmed

Member
Ihave alist of items in alphabetical order. I need to put new records in order automatically when i add them at the end of the list.
 
Hello ahhhmed,


Please download the workbook from the below link:


http://speedy.sh/4m4t7/A-to-Z-data.xlsm


At the last row of the Column A of sheet1, if you enter any letter and press enter, the macro will automatically run and arrange the data in alphabetical order.


The main subroutine is there in Module1, and the same is called(see the Sheet1 code module) in whenever user would make any entry at the last row of Col A of sheet1.


Let me know if this is fine.


Kaushik
 
You must log in or register to reply here.
Back
Top