ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Fill in form to type Item descrictions and costs and fill in funct (https://www.excelbanter.com/excel-worksheet-functions/99558-fill-form-type-item-descrictions-costs-fill-funct.html)

cradino

Fill in form to type Item descrictions and costs and fill in funct
 
Supposing that I have this picture of entrance of costs
A B C
1 Item Cost Input Cost accumulated
2 Item 1 100 100
3 Item 2 200 300
4 Item 3 300 600
6 €¦€¦. 600 1200
7 Item 1000 1000 2200
2200
And that intend to insert a new item with the command to insert line to fill
out the cells A and B


A B C
1 Item Cost Input Cost accumulated
2 Item 1 100 100
3 Item 2 200 300
4 Item 3 300 600
5 Item insert545
6 €¦€¦. 600 600
7 Item 1000 1000 1600
2745

Note that a accumulated value is not correct

It is necessary to enter automaticaly C line value with accumulation
function filled downing. But we need it doing with formulas protected.
A B C
1 Item Cost Input Cost accumulated
2 Item 1 100 100
3 Item 2 200 300
4 Item 3 300 600
5 Item inserted 545 1145
6 €¦€¦. 600 1745
7 Item 1000 1000 2745
2745
How can we that for people to type in the values have not to change formulas?


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com