Hi Phil,

Thanks for the tip, things are starting to become clearer now lol.

The code worked well until i added another two columns into sheet 2 so, I had a bit play with the offset but can only get the values to go into columns D & E instead of B & E.

I tried what you suggested above but it didnt give the result unfortunately

Carl