Copy data, find a date in a row and paste values?

[tonywatsonhelp]

HI everyone,

So every week people add data into an area in sheet "Daily Input"

I need a macro to Copy this data and paste it into the "Years Records" tab

So this Is what I need,

"Daily Input" Range D7:J300 copy

Sheet

"Years Records"
Look along Row 2 and find the date in sheet "Daily Input" cell C4, Paste data in from
that date row 4.

please help if you can

Thanks

Tony
​

 

[ravishankar]

SEE if you can use the macro in https://www.mrexcel.com/forum/excel-questions/1073422-vba-copy-paste-data-worksheet.html
if your format is different, please explain the input and output formats.
ravishankar