Complex: Analysing data with uncertain column locations

The code should fire every time Sheet2 is activated. Try adding a breakpoint on the first line of the code and then toggle between sheets 1 & 2 to see if it is firing.