Currently I have a vba form that I have "shared" for multiple users to use at once. That works fine EXCEPT, each person has to click "save" for it to show up on everyones view of the spreadsheet. The results of the data entered will show up in a scrolling presentation and I would like for it to automatically update each time a person clicks the submit button.

I would like to add a "save" function to the submit button so that it automatically saves each time they submit information. My only issue is, I don't want one persons data to override anothers. Is there any way that I can submit/save at the same time without earasing what was last saved?

Please let me know if you need clarification on what I mean.

Thank you in advance for your help.