I had not explained myself correctly. I needed to have the values pasted into sheet1. But I have rectified my mistake.

Thanks for the concern.
Dave