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 the second sheet. First sheetSecond Sheet

Hi skytube Basically it's: Quantity - COUNTIF([From No.], Logbook code). See attached sample

skytube Can't open your file as it requires CredentialsEither try to attach it here or if not allowed share it i.e. with OneDrive and post the link here

Thank you very much for your time in working on the file and answering my question. It has helped me a lotLorenzo

Lorenzo Could you please assist me in adding this formula to the inventory sheet (yellow-colored cells) in the worksheet below?Logbooks Distribution Index 1.xlsx

inventory tracking system | Microsoft Community Hub

peiyezhu
Bronze Contributor
Jun 10, 2024
skytube

I wold like to record or stock-in and stock-out in one sheet rather than multiple sheets like below:
https://techcommunity.microsoft.com/t5/excel/excel-online-how-do-you-create-order-templates-ordered-to-deduct/m-p/4066825
Lorenzo
Silver Contributor
Jun 09, 2024
Hi skytube

Basically it's: Quantity - COUNTIF([From No.], Logbook code). See attached sample
sample_skytube.xlsx12 KB
- skytube
  Copper Contributor
  Jun 10, 2024
  Lorenzo
  
  Could you please assist me in adding this formula to the inventory sheet (yellow-colored cells) in the worksheet below?
  Logbooks Distribution Index 1.xlsx
  - Lorenzo
    Silver Contributor
    Jun 10, 2024
    skytube Can't open your file as it requires Credentials
    Either try to attach it here or if not allowed share it i.e. with OneDrive and post the link here
- skytube
  Copper Contributor
  Jun 10, 2024
  Thank you very much for your time in working on the file and answering my question. It has helped me a lotLorenzo
- MollyHolly333
  Copper Contributor
  Jun 09, 2024
  that helped me, thanks

Forum Discussion

inventory tracking system

Resources