I can't add attachments due to server issues so I'll try and explain....

I require C19:C29 to be copied to column D in the 'Data' worksheet under NCR & add the date it is copied in column C in the 'Data' worksheet, i.e if it was today's data then it would add 27/03/2013 and copy it over to that column under the correct name i.e Name 1, Name 2 etc

I need this for all the columns that are in the 'Data' worksheet i.e F19:F29 in the 'League' worksheet would copy to column E with the date on the 'Data' worksheet, I19:I29 in the 'League' worksheet would copy to column E in the 'Data' worksheet and so forth....

I hope this makes sense otherwise I will wait until I can upload files again & highlight it within the workbook.

Thanks for your help on this!