firstly, this group is amazing! thank you for the help so far.

I am intrigued to know if this is possible.

can you sort 4 Cells in row automatically when one of the cells changes.

so for example

Row 3 - A1,B1,C1,D1 contains L K J M

What i am looking to do is sort these into alphabetical order (left to right) automatically when one letter is changed.

is this possible in Excel?

Note - Row 3 A1:D1 is pulling the info from another place so can be sorted manually without affecting any other formulas