Hi All,

I have data that starts at A12 in an excel sheet.

What I will like to do is have a vb code that will paste the value of C6 into column P starting at P12.

I will like it to loop based on the data that is in column A.

So for example if I have data in A12, A13, A14 etc then the value of C6 should be pasted into P12, P13, P14 etc.

One last thing I will like to have this in a module where I can call it when needed.

Any help will be appreciated.

Thanks