Slightly complicated question - I'll explain as best as I can.

I have two sheets in a file, one is the weekly sales (all data on one line)
and the other is the previous weeks sales which have been hard coded (1st
week on line 1, 2nd week on line two...52nd week on line 52).

I want the weekly sales sheet to remain the same as it has links into
another report. What I need is a macro to copy the line of data from the
weekly sheet into the relevant weeks line on the previous weeks sheet.

I can only create macro's that take the data from the weekly sheet and
enters it into a specified line in the other sheet. So I need something that
can enter the data in line relevant to the week. I thought about creating a
Combo Box with the dates and using the output of 1,2,3 etc as a guide for the
macro to input the data into lines 1,2,3 etc of the previous week sheet?

Any help would be greatly appreciated.