Bernie Deitrick <deitbe @ consumer dot org wrote:
Your problem statement is hard to follow: You need to
past example tables, showing what you have, and what you
want.

Ok, it's something like this. I'll use less columns:

Value Price1 Price 2 Brutto1 Brutto2
12 54 68 648 816
16 37 46 592 736
--------------------------------------------------------------
28 '44,28' '55,42' 1240 1552

Now, The user enters numbers only in columns Value, Price1 and Price2.
Brutto1 is the product of Value and Price1, Brutto2 is the product of Value
and Price2.
Under the line, we have 3 sums (Value, Brutto1 and Brutto2).

In Excel user can enter up to 2000 rows of Value and Price1 and 2. So, Excel
can't know where is the end because the user can one time enter 20 rows, the
next 400, the third 246 and so on.
So, I want somehow to insert a row (That would be that one under the line
where the sums are) that contains functions in column 2 (Price1) and column
3 (Price2) and when the user calcualtes the sum of Values, Brutto1 and
Brutto2 Excel must automaticly divide Brutto1 with Value and write it in the
cell in column Price1. That's that number '44,28'. Same for the Brutto2 and
Price2.
Can Excel make a row that contains in some cells function?
I'm doing this so the user doesn't have to torture himself with calculating
(he only calculates the 3 sums), he just has to enter numbers and Excel does
everything for him.

Hope you now understand the problem.


--
How does it sound when Darth Vader snores?!