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. https://support.microsoft.com/en-us/office/share-files-with-onedrive-4e871e9a-4cb7-4c66-8b38-d2ee590532c2 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?https://pioneerpharmaceutical-my.sharepoint.com/:x:/g/personal/ahmed_selim_pioneerpharma_org/EW6EEgxwVD5Im0O-BXu_LIABzbwCqGeizb2JOAjZuVQ1BA?e=WLgav3

inventory tracking system | Microsoft Community Hub

11 Replies

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?
  https://pioneerpharmaceutical-my.sharepoint.com/:x:/g/personal/ahmed_selim_pioneerpharma_org/EW6EEgxwVD5Im0O-BXu_LIABzbwCqGeizb2JOAjZuVQ1BA?e=WLgav3
  - 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. https://support.microsoft.com/en-us/office/share-files-with-onedrive-4e871e9a-4cb7-4c66-8b38-d2ee590532c2 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

11 Replies

Resources