Paste values to next unpopulated column within range

Hi

Can somebody please help me with the code to create this macro.

I would like to be able to paste the values of $C$2:$C$10 into the corresponding ares in next empty column, in this case it would be week 5 (column K) populating K2:K10.
Then, if the macro was run again and again, it would populate L2:L10, then M2:M10 etc

Thanks
Marco

This should do only and exactly what you requested. If you want something more flexible, that might also be possible, but we would need more details.

Please Login or Register  to view this content.

Perfect, thanks very much cantosh