Reply to thread

Message: [QUOTE="LarryG, post: 3342016"] I am using an excel spredsheet to keep inventory of parts, I have: A-item B-min level C-items used D-items recvd E-items on hand 1 2 abc 5 1 0 4 3 def 1 0 1 2 I am using formula : E2=B2-C2+D2 However while this work for first time, when i try and input new used item i have to manually add new used to exiting used to get right total for items on hand. I will be typing new data in c2 or d2 as used or recvd and would like e2 to keep udated totals. Is there a formula or precedure for allowing this to happen?-- LarryG [/QUOTE]