Hello,

If i have names in columns O1,S1,W1,AA1,AE1,AI1 etc.
I also have the same names in column B with a value in Column C when the value in C changes i have a macro to update and sort the names and values from largest to lowest.
This all works fine.

But i just can't get when i change a name in either of the column headers O1,S1,W1 etc
i want the names in Column B to also change automatically.

I would upload a sample but when i try to, it fails to upload.

Any help would be appreciated.