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
Bookmarks