Forum Discussion
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 the second sheet. First sheetSecond Sheet
- that helped me, thanks
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
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
I wold like to record or stock-in and stock-out in one sheet rather than multiple sheets like below:
