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.
Part of me suspects this is very simple, I just cant get my head around it.
ActiveWindow.Range("Daily").Value = Range("Report_Date").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Sheets("Grouped Daily Data For Pasting").Select