Finding Text, Offsetting, then Filling Cell with Value

Hello Everyone!

I'm looking to update some code that I wrote a while back, but I'm having trouble fitting the new specs in. Quick overview of what this does - It grabs files in a folder one by one, copies them, and pastes them in a new workbook so they are all on one sheet, it then takes the value from A4, and copies and autofills it down the length of each file copied. I just added the part where it fills in "January" and autofills that down. However, what I'm looking to do now is have the code find "Hello There", offset 3 columns to the left, and the value from there down should be "February" instead of "January".

Please Login or Register  to view this content.

Let me know if you have any questions or need any other info!

Thanks in advance!

Update... I've actually figured out the main issue with my code where I couldn't get "February" to populate. My issue now is getting it to autofill down over some of the "January" cells. Here is my new code:

Please Login or Register  to view this content.

Could someone please help me with that last autofill after "February" is inserted? It should go from that cell to the last row.

Thanks again!