Is it possible to have a dynamic number of destination cells?

For example



A B C D

1 Principle Interest # of Cycles


2 100 1.03 11


3


4



So that for each interest cycle a new principle is calulated and
output to B7, B8, B9 ... b17 or B7, B8, B9 ...B22 if 16 were the value
for C2. And if that is possible can you make a chart using dynamic
cell ranges?

Thanks

TJ








TJ



Life often turns on such small things as a flickering oil lamp.

- Scheherezade -