View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.