Hi,

I have a spreadsheet that equipment is constantly being taking on loan and being returned.

I would like to be able to create something that can monitor the amount of times equipment is being taken on loan, when it's taken, when returned etc. I have a drop down list for each item that is used to select whether the item is on loan or returned from loan, it also creates a date in the adjacent cell to show when it was last changed.

I would like to have some data to creat some statistics and visual representation of useage (pie charts, graphs etc).

Is there any way of doing this?

Thanks!