Macro to move data to anoyther sheet finding the date to add it to including hiden rows?

[tonywatsonhelp]

Hi Everyone,

I thought this would be simple but i'm struggling because of a few unusaul aspects hopefully someone will understand.

So I have sheet Named "All Weeks Data"

This hold my data each week.
in Row 1 are Dates going up one day at a time from 1st JUne 2018

My other sheet is an input sheet for this weeks data called "This Weeks Data"

In column H4 is the start date.

The area I need to trasfer is always the same its Range D7:AD355

so I need a macro to copy the data from

"This Weeks Data"

Range D7:AD355 including any hidden rows.
and paste values into

"All Weeks Data" finding the date from H4 and pasting into that Column from row 7.

hope that makes sense?

Please help if you can

Tony​

_{^{<strike>
</strike>}}​

​

<strike></strike>