row reproduction

P

Pringles.

i recently downloaded the "Bond Amortization" template from they template
page (so i like the templates. is that bad?) and i was intruiged as to how
the workbook created and removed rows automatically depending on, in this
case, how long it would take to pay off the bond. can i duplicate this? i
would like to modify a stock investment calulator so it will shorten/lengthen
depenent on how many stocks they user wants to view at a time. any help?
 
M

Myrna Larson

No, templates aren't bad.

Look at the formulas. They don't "create and remove rows". The formulas return
empty text ("") if there's no entry in column C (or sometimes column D).
That's the usual way to make it look like the number of rows varies. But note
that you have to be sure to extend the formulas down as far as the maximum
possible rows. If you don't, you'll only see information in the columns where
you typed data. The remaining columns will be blank because there are no
formulas there to generate results. e.g. if we're talking about the same
template, the formulas stop at row 73. If you have more entries than that, you
must add new rows and copy the formulas down farther.
 
P

Pringles.

i think i've figured it out. thanks

Myrna Larson said:
No, templates aren't bad.

Look at the formulas. They don't "create and remove rows". The formulas return
empty text ("") if there's no entry in column C (or sometimes column D).
That's the usual way to make it look like the number of rows varies. But note
that you have to be sure to extend the formulas down as far as the maximum
possible rows. If you don't, you'll only see information in the columns where
you typed data. The remaining columns will be blank because there are no
formulas there to generate results. e.g. if we're talking about the same
template, the formulas stop at row 73. If you have more entries than that, you
must add new rows and copy the formulas down farther.
Click to expand...
 
D

Dana DeLouis

Just two cents. The Bond Amortization template is ok, but the basic form
does not really change size. For study, you may want to look at the "Loan
Amortization" template. With this template, it really does look like Rows
are added and removed. It uses Conditional Formatting. One condition uses
a white background to hide data, and another condition to add a lower border
on the last row. When you add in the background color, it looks like the
data area adjusts size. It's a good technique that I am trying to use more
often.
HTH.
 
Top