Hi all,
i apologize in advance if i'll not be able to explain what i need.

I'll try to let you know what i would like to have. My VBA skills are
.... let's say they are not...

Let's say the user has simply to input in cell A1 how many tiers he
wants.
Then i would like the user to be presented with an interface, asking
him to write TWO variables (5 numbers) for each tier he selected PLUS
1. (so if he selected 3 in A1, he will be asked 4*2=8 numbers)
At the same time, I would like one of the two variables in the first
tier, and the other variable in the last tier to be preset to zero,
but the user has to be able to change it.

i would like the user to be allowed to populate the cell A1 with
numbers ranging from 1 to 9, and the Input interface to change
accordingly.

NOW it comes the difficult part....
for each tier, there are several calculations that have to be
performed.
What i have done so far in excel, is creating all these calculations
for all 10 tiers. (for each tier there are 13 rows each time)
My dream would be to ADD dinamically these 13 row everytime i change
the number of tiers in cell A1.

Is that possible? what should i start to read? could you plz suggest
some issue/argument/webpage/previous post that i could read?

thanks a lot in advance