Basically i have tables A to H each of these table pulls data from a different series of cells, and then needs to be sorted with highest first etc.

The code to do the sort is complete, the problem is i have to assign it to an on screen button which is untidy. What i want to do is if any of the reference cells are changed then sort then tables.

I have tried various method but none quite work.
The closest was changing cells to trigger the code but that made the sheet flicker every time the current cell changed (eg moving from A1 to C4).

I did wonder if there was a special sub for on calculation like there is one for auto_open()