I have an Excel list in one sheet with a form attached in a separate sheet -
one is a master list of quotes issued and the other is the form to fill out
to complete a quote. Currently a user has to get the next quote number in
the list manually and then enter into the quote form.

The quote takes the format of Q <next number> <initials>

What I need to achieve is for the user to open the form and be prompted to
give their initials. The form would then grab the next available number in
the list and apply those initials to that number - thus making the quote
number complete. The code would then write that number back to the Quote
Number field of the original list along with a few other details once the
rest of the form has gone about its business.

I can sort of achieve most of this, but the code is very long-winded and
clunky (based upon a macro, basically). I know I could achieve this in
Access however it is causing more problems than it is worth with regards to
linking fields and such - so I need a more efficient Excel code. Can anyone
help?