Hi folks,
The issue I am having is I have tens of thousands of entries in an excel workbook and all of them require different users to put a comment for the ones belong to them. Since there may be up to 100 users accessing the file at the same time, the file has been constantly corrupting.
I have came up with a solution that creating separate spreadsheets base on users' last name so we can reduce the total number of users accessing the same file at the same time. I now have 10 different separate spreadsheets and a master sheet. I have linked all of them together so whatever is updated in the 10 sheets, will update in the master sheet. My issue is now that, a lot of the time, users are not putting in the right comment so I need to modify them and I rather not go to 10 different spreadsheets to do that. I want to be able to modify it in the master sheet.
I am looking for a way to establish a two way link between the 10 sheets and the master sheets. I have a fairly good understanding of VBA and macro coding if it is required.
I understand that Access will most likely fix the issue but unfortunately I can only stick to Excel. If there is any other way to achieve what I need, I am happy to learn.
Thank you in advance!
The issue I am having is I have tens of thousands of entries in an excel workbook and all of them require different users to put a comment for the ones belong to them. Since there may be up to 100 users accessing the file at the same time, the file has been constantly corrupting.
I have came up with a solution that creating separate spreadsheets base on users' last name so we can reduce the total number of users accessing the same file at the same time. I now have 10 different separate spreadsheets and a master sheet. I have linked all of them together so whatever is updated in the 10 sheets, will update in the master sheet. My issue is now that, a lot of the time, users are not putting in the right comment so I need to modify them and I rather not go to 10 different spreadsheets to do that. I want to be able to modify it in the master sheet.
I am looking for a way to establish a two way link between the 10 sheets and the master sheets. I have a fairly good understanding of VBA and macro coding if it is required.
I understand that Access will most likely fix the issue but unfortunately I can only stick to Excel. If there is any other way to achieve what I need, I am happy to learn.
Thank you in advance!
