[SOLVED] Alphabetized data template

What I am wanting to do is create a template where I can enter data in columns A-E, row 2.

The data then automatically enters in alphabetical order in the rows below.

In my example, I have new data in row 2 and after hitting enter or some other key, It will then automatically and alphabetically enter in the rows 3 on.

Is it possible?

Hello Dowjd,

Are you using row 2 as the sole input row, or will all the entered rows be alphabetized when the button is clicked?

Thanks,
Leith Ross

Hi Leath,

Preferably I would like row 2 as the sole input row.

After hitting enter or the like, the data in row 2 would automatically move down in alphabetical order according to column A . I hope that helps.

Is it possible to have a sole input row where the data automatically transfers down to rows 3-1000 in alphabetical order?

The transfer must take all column data in sole input row 2 and transfer it into rows 3-1000.

Does anyone have any suggestions? Can it be done?


Thanks for any help.