Thanks for your help Pierre. As I said, my knowledge of vba is very limited.

Do I just copy & paste this into vba?

And how do I link column A in Sheet 2 to the cell (say cell C2) in Sheet 1? I have tried a formula to point to the cell but I can't get it to work.

Thanks again.