How do I use looping and offsets thru 2 tables to generate a cash flow
per week based on :
a) A given amount
b) A Starting Week Number
c) A Duration expressed in Week Numbers
d) A Value Distribution Curve Code that is used to lookup in Sheet B,
through the corresponding elapsed duration from Sheet A, the
expected % of cumulated cost distribution,
to be applied to the given amount.

Sheet A : The Cashflow Spreadsheet (before processing with VBA)
A B C D E
F G H I J K
1. Amount Start Duration Curve 1 2
3 4 5 6 7 ---
2. 20,000 2 50 B
3. ... C
4. ...(Bottom boundary not known)

Sheet B : The reference curves table
Row 1, Column C thru CX, Duration expressed in % from 1 to
100
Row 2 down, Column C thru CX, Distribution values expressed in
cumulated %

A B C D
E F G H I ... CX
1. CurveCode CurveName 1 2 3 4
5 6 7 ... 100
2. B Low-Wide Peak .4 1.3 2.3 4.3
5.4 6.4 7.4 ---
3. C ...
4. ...(Bottom boundary not known)


Sheet A : The Cashflow Spreadsheet (After processing with VBA)
A B C D E
F G H I J K
1. Amount Start Duration Curve 1 2
3 4 5 6 7---
2. 20,000 2 50 B -
260 920 ... ... ... ...


Each week % Duration from sheet A Cell C2, is worth 2 % out of a
total duration of 50 weeks.
Finding 2 % of duration on sheet B corresponds to Cell D1.
and for Curve B the cumulated value at this point is given in Cell D2
as 1.3%
1.3% applied to the given amount to be distributed of 20,000 is equal
to 260 in Cell F2 of sheet A.
The second Week in Sheet A is equal to a cumulated duration of 4%
which corresponds to
Cell F1 in Sheet B as 4.3 %, and in Sheet A Cell G2 to 920. (20,000 x
4.3%)
.....

Your help will be appreciated,

Celeste