I was advised to come to this part of the forum to see if anyone had any ideas on automating this somewhat.
The solution works great but it quite a lot to set up for what its doing. Could it be something a macro could do? By the way I haven't got a clue how to start with macros!!!