skytubeCopper ContributorJun 09, 2024inventory tracking system Hello, how to establish an inventory tracking system in Excel utilizing Logbook codes when a form No. is entered in the first Excel sheet, the corresponding quantity is automatically deducted from t...Show More
LorenzoSilver ContributorJun 09, 2024Hi skytube Basically it's: Quantity - COUNTIF([From No.], Logbook code). See attached samplesample_skytube.xlsx12 KB
skytubeCopper Contributor to LorenzoJun 10, 2024 Thank you very much for your time in working on the file and answering my question. It has helped me a lotLorenzo
