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.
|