Automatically sort sheet by column2 when any value in column2 is changed

[babbeleme1]

Hello,

I'd like to be able to automatically sort my Sheet1 according to Column B, whenever a value in Column B is changed.

Then, if the value is changed to "F", "J", or "K", I want to highlight that entire row.

Please Login or Register  to view this content.

I have this sketch of a code, which I typed into Sheet1 > View Code, but it's not working at all.

[xladept]

Try this:

Please Login or Register  to view this content.