How user Form can be accessed by multi user in online?

Dear Forum,

I need your support and guidance on the following:

I have developed 3 data entry tools using user form in excel 2013. All three user forms are in single workbook. These three user forms have been linked with other user form as interface to open and enter the data. When i open the excel file, user form will display first. I use this user form as interface. In this user form 3 user form has been linked through command button.

Actually i have nearly 120 staffs across my country. All these 120 staffs are using this tools to enter the data in off line and share it with me through mail. I am download every sheet and consolidating using macro code and doing my analysis and report everymonth.

Needed Requirement is:

Is there any possibility to keep this excel file in "One drive" or "Server" and ask 120 staffs to do a data entry in that excel file. Then i can get the consolidated real time entry? Or else kindly suggest me something meets my requirements.

I want my 120 staffs to access this excel file in online and i want to get the consolidated database.

Thanks in advance and your small help will also be appreciated.

Regards

Ultimately- You're going to want to use a real web server + database + server side scripting setup, what you're asking to do with excel is outside the scope of what excel can handle.

I would recommend looking into an app called xampp (https://www.apachefriends.org/index.html) apache + php + mariadb, 1.) it's free 2.) very easy to setup and run, get your feet wet with web development and you won't regret it.

Dear Mr. Poizhan,

Thanks for your positive thoughts and showing me a way to do try something on it. I will try and come back if any support required. Thanks a lot again.

Regards