Automatically Sorting Values after Entering a New Record using Excel VBA 

This is a great example of what can be done to record and sort our data. Interesting for my responsibilities as a GA.

Even though VBA is still confusing to me, this video was very concise. If I work with this program in the future, I will definitely be sure to utilize this playlist!

I've just recently started using Excel more for work so I was really interested in learning how you automatically sort values after entering a new value in a field. It's highly useful and I'll definitely use it in the future!

I do not know much, if anything, about writing code, but it seems useful when trying to sort the data, especially if there is a lot of it. This video explained things step by step, so it should be fairly easy to replicate.

I have always appreciated learning how to write in code because I think once you get the hang of it, it makes things a lot easier when manipulating data. I appreciate how coding was shown how to be used in this video.

I am intrigued by this and I love organization. I would have to watch this video again to fully understand but when I get the hang of it I think this can be fun.

Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 2 Then Dim lastRow As Long lastRow = Cells(Rows.Count, 2).End(xlUp).Row Range("A2:B" & lastRow).Sort key1:=Range("B2:B" & lastRow), order1:=xlAscending, Header:=xlNo End If End Sub You're welcome. ;)

I really like Excel and think that it is a good tool due to being able to sort your values and data automatically. Overall, this video was good and helped me understand how to use Excel more.

Hi! What if I'm typing a text (letters) vertically in just 1 column, is it possible to sort automatically after typing?

Where did the code come from? I replayed the beginning a few times but I'm still missing that part.

How do you do this for more than 2 lines of data? I am trying to sort about 8 lines of data and I am unable to make it sort correctly

Having no experience with VBA this wasn’t too helpful

this was excellent and saved me a lot of time.

This would be a useful tool when there is a lot of data; I'm not very familiar with formatting code for excel but it seems pretty straight forward.

When entering you're data this way, that has hundreds of lines, is there anyway to automatically jump to that same cell that has most recently been entered and sorted? (Without using ctrl + F)

This code works great! Thank you! However I can't get the worksheet to recognize the change when new data is added via Data Entry Form. Any Ideas on how to get it to recognize new data to the column this way?

I have 4 columns I am trying to auto sort as data is added: Patient Name Patient DOB Patient Phone Recall Due: I need the data from the 4 columns to sort by the Recall due date. I can not figure out the code to do this. It needs to go in ascending order by date.

Sir, It's awesome. Is it possible for set print area that should fit to the data automatically without pressing any button as the manual data or for the data imported from another worksheet. Please provide me such a code.

Please I need code to make this action As if I manually put the cursor inside cell a1 and then Inter, then I put the cursor inside cell a2 , then Inter, and so on

Hello Mater Hiya, I want to sort one column with a switch so that after entering data it will set ascending order. Address is Column K7 and down to K2507, Row 1 to 6 have Titles and some displays. (VBA With a Switch to apply sort) so yer ...leave it with you to hear back

Private Sub Worksheet_Change (ByVal Target As Excel.Range) If Target.Column = 2 Then Dim lastrow As Long lastrow = Cells(Rows.Count, 2).End(xlUp).Row Range("O25:P" & lastrow).Sort key1:=Range("P25:P" & lastrow), order1:=xlAscending, Header:=xlNo End If End Sub Не благодарите

This video was interesting. I know little about writing code.

This is very helpful, thank you!!!!!!!

Thank you very much for this. Great help.

Can I use this code to sort the dates???

This video is interesting. I would like to know more about the coding process after watching.

what if i only want to sort for example a2:b - a13:b13 not the whole column

Hi Dr. Todd Grande, thank you for this script, can you please help me to sort dynamic data in excel. my data is updating from Web

I use Numbers, a mac spreadsheet. Have any instructions for that?

Thanks dear for that video please let me know how I can arrange data to specific irregular data by EXCEL VBA

Can you please post the code aswell :)

Can this be done with a Google docs spreadsheet?

I need same story But For excel format as Table NOT for Normal Range

thanks sir you are genious

Great code and video! Solved my issue. Thank you for this!

thank you if i want to choose sort column by drop down list

Sir I am fresher in Excel VBA I have an Excel sheet in which many dates are written in column A and other data in column B to G. I want to create a combo box in userform which shows months (mmm_yy)of the month in which the dates are written in the column A.and I want to create a command button for autofilter data of the month which I select from combobox. suppose I have written many dates of April 18 , may 18 , June 18 , July 18 , December 18 and January 19 in column A so in combobox dropdown list shows April-18 may-18 June- 18 July 18 December 18 and January 19. Suppose I select June 18 from combobox dropdown list so autofilter sheet data of June 18 when I click on command button and copy filtered data to another sheet by another command button but duplicate entry avoid. Please help Thanks in advance

anyone knows the way to get the same result without using VBA?

I sent you message on your private messages please open it ..

Excel seems a little more complicated than SPSS. I agree that it would be more useful with a lot of data

This is very helpful! Could this be done with date values as well? If so, how would I do it?