I want to share some data between workbooks that I have. So that when data is entered in Book1 I want that data to also be shown in Book2. But if the user of Book2 decides to change the data, it should be reflected in Book1.
Currently I see two ways of solving this.
1: Using the share workbook feature with linked cells. I'm not sure how to go about setting up my workbooks using this method though.
2: Using VBA coding. I have the data linked right now so if changes are made in Book2 it changes Book1.
This code only works one way right now. So if the user wants to make changes in Book1 after it won't work.
Bookmarks