auto sort upon entering data

November 30, 2016 at 10:49:27
Specs: Windows 7
I am looking for a simple, VERY simple solution to automatically sort data as it is entered. I have columns A:G and may add more columns later, I will continually add rows, daily. I don't not want to have to sort this manual through the sort function. I want to enter the data in the row, press enter and it sort itself automatically. I have only come across sample macros that are specific to the posters questions. So here is my attempt. I want the entire document to sort anytime I put new rows in. WIN10, Office suite 2010

message edited by adavis82


See More: auto sort upon entering data

Report •

#1
November 30, 2016 at 15:38:04
What do you mean by "add rows"?

Do you mean that you are inserting rows into the spreadsheet or do you mean that you entering data in existing rows at the bottom of your data?

In addition, it is not clear what column you want to sort on and when you want it to happen.

Please clarify your requirements.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
November 30, 2016 at 16:12:15
I have a simple spreadsheet, with 5 columns. The spreadsheet is already at 120 rows of data. I will add data to this sheet every week. So no I am not adding rows, I am adding data to exist rows. When I enter data into a row and hit enter, I want that entire row to automatically go to where it needs to go based off of alphabetical order, so I guess you could say based off of column A. I am very new at this, if you can't tell :)

I may add additional columns at some point so I would like to know how I would edit the code later to include that column in the sorting.


Report •
Related Solutions


Ask Question