Auto Sort New Entry

[Nardi0923]

Hi everyone!

I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughing

I have a spreadsheet of 9 cells across A4 - I4 (white)and around 900+ down (but will be adding to this number and that's where you all come in...). It'a a list across of company names, legal name, street address, city, state, zip, phone numbers, website and business type. I want to be able to pick a cell like A3 (green) to entering all new info across then click a cell preferably A1 (blue) to be formulated to "Auto Sort" where it will put the row alphabetically down where it below...simple right? I worked off a spreadsheet at my previous job and can work within it, but have no idea how to create one?

Can you help?

NardiScreen Shot.jpg

[jason.b75]

You could insert a new row by right clicking, enter your data into that row, then sort from the 'data' tab in the excel ribbon.

You could automate the process with vba but personally, I think it is one of those simple tasks that is better done by hand.

[newdoverman]

You already have a table that has the controls with each heading (little white square with a triangle in it). Eliminate the green for the first row as it will get sorted down the table when the table is sorted.
Fill in the data for the new record. Click on the square attached to the company name header and sort A-Z. For your next entry, right click in the first row and select Insert and select Table Rows Above. This will insert a new row for data. Fill that in and then sort.

A shorter way to do this is to enter the new data immediately under the existing table. The table will increase in size to include this new row and all you have to do is sort to put the new data in its correct place in the table.