Finally working... I only waited 20 seconds. Yet I have quite fast net for mobile (25mbs) so not sure where the logjam.
Anyway working.
First thing I would like to change is the formatting for the ALL page. Is that linked to the other sheets or is populated by vba script?
ie market Capital shows as XX.XM which I want fromatted back as full number XX,XXX,XXX.
Cheers
Sonic