VBA copy data in a row and Paste in a separate row based on the weeks date

[WingchairAndy]

Hi

The table on the right updates automatically based on the data for that week. What I want to do is then copy & paste the data into the table on the left based on the latest date - which changes each week. The date in the column on the left do not change, so effectively I want to copy the data in the right hand row, run a lookup based on the 19/07/13 and find the 19/07/13 in the left table & paste the row data so it creates a weekly collation of data.


Any help would be appreciated

Regards

Andrew