Data Query + Table + Bi-Directional Sync

[cscotty]

Hello All.

I have an issue that I hope you can help with please .

Question
Let me ask the question first, then I'll explain: Is it possible to set up a bi-directional sync between two tables using data query (or any other functionality)?

Problem
I have a main workbook (WB1) with a sheet that has a table (TB1) consisting of data. I created a new workbook (WB2), and used data query to create a new sheet in WB2 that consists of the table and data in WB1. This new table in WB2 is named TB2. When I edit data in TB1 and run the query, it synchronizes over to TB2, as expected. This works perfectly. However, when I edit TB2, the data does not synchronize over to TB1. I understand that I have not configured the query to do so, so technically it's working as expected.

This is where my question above comes in. Is it possible to set up a bi-directional sync between TB1 and TB2 using data query (or any other functionality)? I would like the table with the latest saved data to synchronize to the other table upon running the query, whether its TB1->TB2 or TB2->TB1.

Any help will be most appreciated.

Thanks so much!

 

[bobsan42]

I pressed the like by mistake ?
I sounds like a crazy idea. Reminds a bit of database replication, but with a twist of wrongness in it.
I can think of too many ways for this to go wrong.
Why cannot you directly edit TB1 ?
The queries are not bi directional.
And in my mind two sets results of each other are an infinite loop.

 

[cscotty]

I pressed the like by mistake ?
I sounds like a crazy idea. Reminds a bit of database replication, but with a twist of wrongness in it.
I can think of too many ways for this to go wrong.
Why cannot you directly edit TB1 ?
The queries are not bi directional.
And in my mind two sets results of each other are an infinite loop.

Thanks for the comments.

Ideally, I have a table (TB1) in WB1 with rows that describe an assignment that needs to be done. The last two columns of the table is "Assignee" and "Comment". I insert the assignee name in TB1, but leave comment blank. Then I run the data query and synchronize all values in TB1 to WB2, TB2. When the assignee opens WB2, they will see their assignment in TB2. They will then enter comments based on their assignment (comments will be required for every row) in TB2. I would like the comments that the assignee enters in TB2 to synchronize over to WB1, TB1.

Any chance of that happening?

 

[bobsan42]

Vba to write it back to tb1.
But not another query.

 

[cscotty]

Vba to write it back to tb1.
But not another query.

Thank you. I'm checking the forums now for code examples. Would love if you can take a look at it once I find something, or suggest a starting point