Shared worksheet and form function
 

The scenario: Several co-workers trying to access the same worksheet to enter
details and retrieve a reference. I think I need a standalone form that takes
the details and minimises the time trying to save the data and return a
reference - i.e. write access is kept to a minimum time frame. Otherwise lots
of waiting whilst updating, even if copy and pasting.

E.g. Simple form with required fields. If attempt at save is successful then
a reference is returned, else retries until so.

Any advice appreciated, as I really need to make the time savings. I'm sure
it's been done a dozen times already so if you know of a place I can find
it...?

Cheers.