Auto sort multiple columns using VBA when a value is changed.

[Tamara551]

Okay, this is my first time coding. I need to sort by multiple columns when a value is changed. I figured out how to auto sort by one but not by multiple. I have just been researching other coding suggestions and trying to make them by own with no luck. I need to sort the columns when column E value is changed. I want to sort by column A, then E, then B. Please help. I can get it to work by F5 with some of the codes I used but I cannot get it to auto sort.

 

[dermie_72]

Try changing the

.sortfields.add

to

.SortFields.Add2

See if that helps.