N
NeedToKnow
I have had a lot of help here and almost always answer if found with search.
Now I couldn't find such so here it comes.
I have a file whereare columns A: freight numer B: date C: sort D: km E:
amount ... H: eur per frieght
One freight might have 1-7 rows, because each sort (pine, birch etc) makes
own row.
Now I need to find a way to have column I adding total eur per freight. The
problem is that this formula should be already in the cells, so when user is
writing information, sums are appearing without they have to do anything. BUT
the sum should appear only to the last row of the freight. Columns don't have
to be in that order, position can be changed.
Example:
freight date sort km amount/tn ... eur total eur
12 16.1.09 pine 15 27 270 270
13 16.1.09 birch 16 10 150
13 16.1.09 pine 18 12 170 320
This can be made almost how ever, most of cells will be protected. Users
don't know very much about Excel. Thanks in advance any ideas.
Now I couldn't find such so here it comes.
I have a file whereare columns A: freight numer B: date C: sort D: km E:
amount ... H: eur per frieght
One freight might have 1-7 rows, because each sort (pine, birch etc) makes
own row.
Now I need to find a way to have column I adding total eur per freight. The
problem is that this formula should be already in the cells, so when user is
writing information, sums are appearing without they have to do anything. BUT
the sum should appear only to the last row of the freight. Columns don't have
to be in that order, position can be changed.
Example:
freight date sort km amount/tn ... eur total eur
12 16.1.09 pine 15 27 270 270
13 16.1.09 birch 16 10 150
13 16.1.09 pine 18 12 170 320
This can be made almost how ever, most of cells will be protected. Users
don't know very much about Excel. Thanks in advance any ideas.