Hi Alastair,
Thanks very much for your help. Unfortunately when I tried using the macro on the actual data (which I cannot post as it is confidential), I got several errors. I have also tried this macro that I found yesterday on another site, which seems to be more what I need.
However, again coming up with some errors and I'm not sure why or how to fix all of them. I'm a complete novice at all of this and can't work out the mechanisms, which would give me a grasp good enough to solve my problem.
Regards,
Fearghas
Bookmarks