Hi everyone i need help doing this simple inventory, i really have no clue on how to do it. ask me anything about alarm and cctv systems and i will be able to help but when it comes to excel im the biggest dumb at it.
so i have already figured out how to add from cell quantity E, tech1 F, tech2 G and come up with total at total H, what i want to be able to do is if i add tech1 "F" x amount it will automatically subtract from "E" quantity and the same for tech2 "G" and show the total in "H"
Quantity is what i have in stock at the office
tech1 is what he has in there truck


tech2 is what he has in there truck
total is my overall stock

Attached Images

Capture.PNG (141.5 KB, 29 views)

Attached Files

Office.xlsx (13.3 KB, 12 views)