Multiple Users in a Shared Workbook

Hi Folks,

Need some brainstorming/ideas here. As you are reading keep in mind that Access is not an option (just isn't).

I have a worksheet, the read/write access to which I need to distribute to several users (20ish). How can I accomplish this?

My initial thought was to duplicate Front-End Forms/Back-End Tables in Excel, and have a second workbook with VBA code behind it, acting as an input form, and then copying and pasting rows from wbk2 into wbkmain, but even with a shared workbook we run into complications when it comes to saving the data at the same time.

Please troubleshoot/assist.

Thanks!

*Bump**Bump**Bump**Bump**Bump*