Macro to Paste beside a certain date

[ardykav]

Hi All,

I have two sheets, Weekly Sales and Yearly Sales. Column A on Weekly Sales has the 7 days of the week running from cells A10:A16, On the yearly sales the dates run from cell A3:A368.

The idea is that the weekly sheet is populated and then a macro copies all data from the weekly sheet (B10:E16) and puts it into the yearly sales sheet beside the relevant date in column B.

All help greatly appreciated,

thanks

 

[ardykav]

Anyone any idea on the above?

 

[ardykav]

Still trying for an answer to the above?