Keeping track of what items and who took them in Excel

[Nalasmum]

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 stock level goes down and it is logged in the spreadsheet I can see who has taken it and how much is left.

Colleague 2 takes some of the same raw material from the cupboard and the stock level goes down and it is logged in the spreadsheet.  When my spreadsheet updates it only logs who has taken it last and not who has taken it previously. 

Is there a way to log who has taken what and when that doesn't overwrite previous data.

Hope that is clear

Jane

[#2]

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.