I have an Excel spreadsheet that I fill in each time I issue a new letter number to an engineer working on our project. The engineers have to email me for a new number. I would like them to get their own numbers to save everyone time. We have tried allowing them access to the Excel spreadsheet, but they always mess it up completely very quickly and cannot be trusted to have access to it.
Is there any functionality within Excel or an existing, small, cheap, simple programme that we can purchase, that will allow them to log in with a username, complete two or three fields, which will allocate them the next number in sequence, fill in the spreadsheet, and will not allow that number to be used again?
I suppose I am loking for a very small, simple form filling programme?