Can I set 2 spreadsheets to autopopulate each other when data is entered on one?

[steve80s]

I have 2 spreadsheets that contain the same tables. One of them has hidden rows and protection to stop users of that one from viewing some of the information. I know it's easy to set one to show data from the other with a formula like this...

=IF(ISBLANK('[Wood Street Room Booking Diary.xlsx]Tues 07-05-2024'!I5),"",[Wood Street Room Booking Diary.xlsx]Tues 07-05-2024'!I5)

However, this is obviouosly one-way. Is there a way of setting it up so that when someone enters a value in EITHER sheet, it automatically displays it in the same location of the other please?

 

[Jeffrey Mahoney]

I have seen this kind of question before. A macro could be created to copy values from either to both.

It seems like your providing data based on the user, true? It would be better to provide only the data they need to see and allow them to edit records. So what I do is create formulas that pull records from the main database based on their name and show all of those with filters. Above the list of records I create controls that populate details for one record they have chosen to edit, allow them to make changes, and save to the main DB. Of course this requires some coding to get data moved around.

But, if the data on Sheet1 is in the same location, cell by cell, than an easy macro could be created.