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.