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".
Let me know if you have any questions or need any other info!
Thanks in advance!