VBA for looping

[vanitarathod]

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

[sktneer]

May be this.....

Please Login or Register  to view this content.

[vanitarathod]

Hi sktneer,

thanks for your response. Can I attach excel sheet for more clarification

thanks

[sktneer]

I think the code does exactly same as per your requirement in post#1. But if you have not explained your requirement well enough, upload a sample workbook along with the expected output filled manually and let me see if I can assist further.

[vanitarathod]

Hi sktneer,

Please find attachment which has data and instructions in it

thanks