Copy value based on dynamic input

[Carlotta1989]

Hey all,

I have a problem and have NO idea how to solve it - it is about a dynamic sheet that should show a timeline (Calendar weeks) and quantities in that timeline. Attached is an sample workbook with all information -> 20230522_SAMLE_WORKBOOK.xlsx

But here are additional information:

B12 & B13 has masterdata, meaning how many weeks each activity takes.

Row 2 has the actual entry table and a auto-filled timeline below (rows 3 & 4). I need help on formula's for the auto-filled timeline.

The table has in it's first rows quantities per calendar week (usually either 0 or 1) based on the entry table. Now, in the rows below, I need to copy the quantities with a dynamic "move" to the right.

Let's say we have defined that activity A takes 3 weeks (B12 = 2) and E2 a "1" is manually entered. I now want to row below to take that 1 and copy it 2 cells further to the right (in this case in G3) as the activity takes 3 weeks and therefore output of that would be 2 calendar weeks later. But if I adapt B12 to e.g. 3 weeks, it should then take 3 weeks, so paste the 1 three cells further to the right in the row below.

I hope this is understandable - please help me .

THANKS!