Add Cell Content N Rows Above

Hi there,

I'm creating a marketing schedule and want excel to copy the contents from cell X, and add the content N rows above it.

For example, I want to add Cell A52 "Valentines Day" 40 cells above:

Ideally I can automatically add text to the end of the content in the new cell.

Eg, "Valentines Day" + "Product Launch"

I'm looking to do this for multiple intervals

Eg, Adding it for 40 days, 20 days and 10 days

Final Result

Rows: Event | Start

"Valentines Day" + "Product Launch" | Jan 6

(39 rows)

"Valentines Day" + "Halfway" | Jan 26

(19 rows)

"Valentines Day" + "Sale" | Feb 5

(9 rows)

"Valentines Day" | Feb 14

Thanks for reading this! Can you can help?