enter a value and have excel populate a table with that many rows
 

This may be a bit confusing, but I was puzzling over this over the weekend
and can't figure out a solution. I'm assuming the answer to this lies in VBA.

I have in mind a template for calculating bond interest payments. What I
would like to do is to enter the number of periods, say 30, and have Excel
automatically populate a table with 30 coupon payments.

I can figure out all the bond math by myself. What I don't know how to do
is, given a value entered in a cell, have a table populate with a number of
rows equal to that value. So, if I decided that instead of a 30 period bond
I was interested in a 15 period bond, I could change 30 to 15, and Excel
would automatically shrink the table.

I doubt this is impossible, but I do know it's beyond my VBA knowledge.

Thanks,

Dave
--
Brevity is the soul of wit.

enter a value and have excel populate a table with that many rows
 

Dave F wrote:
This may be a bit confusing, but I was puzzling over this over the
weekend and can't figure out a solution. I'm assuming the answer to
this lies in VBA.

I have in mind a template for calculating bond interest payments.
What I would like to do is to enter the number of periods, say 30,
and have Excel automatically populate a table with 30 coupon payments.

I can figure out all the bond math by myself. What I don't know how
to do is, given a value entered in a cell, have a table populate with
a number of rows equal to that value. So, if I decided that instead
of a 30 period bond I was interested in a 15 period bond, I could
change 30 to 15, and Excel would automatically shrink the table.

I doubt this is impossible, but I do know it's beyond my VBA
knowledge.

Thanks,

Dave


Hi Dave,

I think you could use Conditional Formatting to show the number of rows you
want based on the number you input in a cell, but you have to input the
formulas for in a reasonable number of cells, using IF and so on... I think
it shouldn't be difficult... If you need some help, you could upload an
example file with the formula for calculating bond interest payments to
www.rapidshare.de.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy