Hello Paul, sorry for dropping off of the radar, my wife got sick and I had to fly home for a couple of weeks.
I just wanted to let you know I have managed to get the file you sent through to me working (when I first tried to run the macro it told me the macros were disabled and would not work, I figured out I needed to have the file in a trusted location for it to run), it is now doing exactly what I need it to do. Thanks for your help and patience.

James