Forum Discussion

Copper Contributor

Jun 09, 2024

inventory 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...

Excel

skytube

Copper Contributor

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
I apologize for any inconvenience
https://1drv.ms/x/c/558266e921a17e41/EXpNZgX1FmdDpP1UlOMYFOMBmjJwkEbZ1udXZyk7aLWjhg?e=4ss4M5
- Lorenzo
  Silver Contributor
  Jun 10, 2024
  skytube OK, I see your challenge: your Codes are on different sheets. Easiest way will be to Append/Combine them all on an (hidden) sheet, then do the calc.
  
  Which version of Excel do you run?
  On which platform (Windows, Mac...)?
  - skytube
    Copper Contributor
    Jun 10, 2024
    Excel 365 , windows

Forum Discussion

inventory tracking system

Share

Resources