Hi,

I am new to vba. I want VBA to copy cell a1b1 and should be pasted in c1d1. In the same way, copy a2b2 and paste again only in c1d1. This should be repeated till data in column A B is present. I mean copy data from AB column and paste only in cell C1D1.

thanks in advance