Help VB to copy data and paste in cells next to a date that matches an input

Hi

Would be very grateful for any help with this.

I am trying to write code that will copy a named range of data from sheet 1 then go to sheet 2 find the date in the named range that matches a date entered in cell c1 of sheet 1 and paste the data in the cell to the right of the correct date.

I have only knowledge of modifiying exsisting code so writing new is proving difficult. Here is an example of feeble attempt which doesnt work.

Code:

---

Range("test").Select
    Selection.Copy
    Sheets("destination").Select
    ActiveWindow.Range("Daily").Value = Range("Report_Date").Select
    ActiveCell.Offset(0, 1).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Sheets("Grouped Daily Data For Pasting").Select

---

Part of me suspects this is very simple, I just cant get my head around it.