How to do automatic sort in Excel
I am wondering what function or code for a macro I need to do an automatic sort in MS Excel. I have names in column A and corresponding Starts in Column B. I want columns A and B to be sorted in descending order automatically every time I enter a value in column B so that I don't need to click on "Sort Descending" in the tool bar.Excel screen shot.JPG
Last edited by mukesh123; 02-04-2015 at 11:48 AM.
Took a shot..see if this what you are looking for. Next time upload a sample file.
Hello Sender,
It is working for numbers. As numbers are changing and starting with priority high numbers. But It is not applicable for names and names are not changing as it doesn't follow the correct order. could please do a favour for me to change the names and numbers at a time.
Thank you,
K.Mukesh
Last edited by mukesh123; 02-04-2015 at 11:46 AM.
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
mukesh123 - it seems to be working for me...both numbers and names
like FDibbins said, please upload a sample of data and what you are expecting to see
(thanks FD!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks