Thank you for your solution which I look forward to implementing. I didnt realise how closely linked these forums were and apologies for the unnecessary duplication of effort. Previously I had been working on Joomla where the forums seem disconnected so I commoinly posted a question in different places.
I appreciate your time and expertise. VBA is very new to me and its proving an interesting and challenging exercise.
I can confirm the code works beautifully. I will have to spend a lot of time understanding the coding which looks quite advanced.
Thanks again
Derek Sharp