Two Way link between excel workbooks

tyler2000

New Member
Joined
Jan 22, 2018
Messages
4
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!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,136,260
Messages
5,674,682
Members
419,520
Latest member
Jennifer4Dillon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top