I currently have a spreadsheet running an algorithm on data and generating quotations in a worksheet. The user is then able to export the data to save it into the 'cloud' so the quite can be recalled and modified by other users. The way I have done this is not elegant!

It saves the data in a compressed format into a second excel document stores in OneDrive with collaboration. It works 99% of the time however if one users OneDrive becomes out of sync for any reason they will get repeats in quote numbers or not be able to see other users data. The system is now being used considerably more and the number of errors seem to be compounding as a result.

Would using an SQL database solve this problem? It would need a VBA macro to locate the next available quote number, and fill in the compressed data in the next cell and it would need to be available to other users instantaneously to avoid duplication. If so, what would be a cheap service to host this on as the file would only be a few megabytes and changes would only be a few kilobytes?

Adam