Equipment Booking System

Hi Guys,

What i'm about to request is extremely complex(for me anyway) and I would love it if someone can help out here.

Basically I want to create a sort of equipment booking system within excel, however I'm wondering if it is possible or not, this is the scenario.

For one day we might have 3 microphones available, thats great 3 people should be able to book one out each time, lets call them Mike, John and Kate. However John decides to be greedy and book 2 microphones instead of 1, so now since Kate was the last to try and book it shows her that she cannot book it as there are no more microphones available.

I'm also wondering if it would be able to track things like how many items they booked last month.

Also is it possible that this could be done completely on google sheets at all? (i love the feature that only lets you access all of the document while only letting others access what you want them to)

I really hope it makes sense, if you guys need more information from my part please feel free to let me know.

Not without a huge amount of work. Honestly, you'd be much better off spending a few quid on an asset tracking package - it's much easier, robust and probably much cheaper than trying to do it yourself - have a look at something like http://www.ezofficeinventory.com/

You wouldn't do this in a spreadsheet if you were designing it yourself anyway, you;d want a database.