Put in Alphabetically Order as You Enter

**kuzna26** · 04-12-2013, 04:35 PM

Hi Guys ,

Please is there any way in excel put put the text in alphabetic order as you enter

In column A will be a list of part and Column B the part number
I would like to have a formula that automatically put the text in Column A alphabetically order
as you enter ie.

A1 : Cooling .....................B1 78177
A2 : Exhaust ....................B2 N785
A3 : Air Filter.....................B3 0912 ( aHere as I enter this text it should be placed automatically in A1 and B1 )

Thank you

**rollis13** · 04-12-2013, 05:19 PM

Have a try with something like this (but I'm sure it could be done in a better way) in your sheet object code:

Please Login or Register  to view this content.

**Kevin UK** · 04-13-2013, 05:26 AM

Hi kuzna26

I think you will need vba, but see the attached sheet for a formula approach.

There are 2 dynamic ranges for: Column P=Item & Column Q=Codes these run to row 100.
Input your data in P & Q and the results are listed Alphabetically in column A with the relevant value in B.