Add relative formula to next column

Thanks for your help, the macro does the work. Shamefully I wasn't clear enough of what I wanted to achieve so I will rephrase and
add a better example.


- I want this macro to be part of a larger routine, so would like it to have it work without the need to right click. Instead I would
like to run it manually (through alt + F8 -> execute).
- I want this macro to overwrite one cell at a time, everytime I run this macro (like yours already did).

I added a new example to give a better understanding. I used the real layout, so I did hide some rows so the texts are in the right row
and column number. I limited the example to 5 weeks, in reality it goes on and on. The coloring in the cells is just to
make it more clear, in the real file the coloring isn't there.

Hope you can help me out again.

Cheers.