Macro to paste data periodically

[excellearner16]

Hello,

I have two set of data:

First data set: This data set contains monthly base cash flows for a project:

Month	1	2	3	4	5	6	7	8	9	10	11	12
Cashflows	C1	C2	C3	C4	C5	C6	C7	C8	C9	C10	C11	C12

<tbody>
</tbody>

Second data set: This data set contains business volume growth:

Project	Cashflows starting period	Expected cashflows
Project 1	Immediately	100% of the above cashflows
Project 2	After 6 months	200% of the above cashflows
Project 3	After 12 months	300% of the above cashflows

<tbody>
</tbody>

I am looking for a macro / formula to combine future projected cashflows for all the projects. The total projection for all project should be the total column below:

Month	Project 1	Project 2	Project 3	Total
1	100%*C1			100%*C1
2	100%*C2			100%*C2
3	100%*C3			100%*C3
4	100%*C4			100%*C4
5	100%*C5			100%*C5
6	100%*C6			100%*C6
7	100%*C7	200%*C1		100%*C7 + 200%*C1
8	100%*C8	200%*C2		100%*C8 + 200%*C2
9	100%*C9	200%*C3		100%*C9 + 200%*C3
10	100%*C10	200%*C4		100%*C10 + 200%*C4
11	100%*C11	200%*C5		100%*C11 + 200%*C5
12	100%*C12	200%*C6		100%*C12 + 200%*C6
13		200%*C7	300%*C1	200%*C7 + 300%*C1
14		200%*C8	300%*C2	200%*C8 + 300%*C2
15		200%*C9	300%*C3	200%*C9 + 300%*C3
16		200%*C10	300%*C4	200%*C10 + 300%*C4
17		200%*C11	300%*C5	200%*C11 + 300%*C5
18		200%*C12	300%*C6	200%*C12 + 300%*C6
19			300%*C7	300%*C7
20			300%*C8	300%*C8
21			300%*C9	300%*C9
22			300%*C10	300%*C10
23			300%*C11	300%*C11
24			300%*C12	300%*C12

<tbody>
</tbody>

Any help will be greatly appreciated

 

[excellearner16]

Excel gurus - Please let me know if you need more information. Any response on this will be greatly appreciated. Thanks