Forum Discussion
Nalasmum
Oct 23, 2023Copper Contributor
Keeping track of what items and who took them in Excel
Hi All I have a stock list and I want to be able to track what has been taking from the stock cupboard and by who. Scenario: Colleague 1 has taken some raw material from the cupboard and the sto...
mtarler
Oct 24, 2023Silver Contributor
I don't know how your sheet is set up but I would say create a LOG table so every time someone interacts with the cupboard it is logged on a line:
date (&time if needed), name, item, quantity (define +/- for taking/returning)
Then you can have a 'report' that will tally the quantities for your inventory but this table will show all information. You can also have a report for all people where take>return per item.
date (&time if needed), name, item, quantity (define +/- for taking/returning)
Then you can have a 'report' that will tally the quantities for your inventory but this table will show all information. You can also have a report for all people where take>return per item.