Cross Link/Sync cells where you can change either

**nature47** · 07-12-2009, 02:09 AM

Hello,
In Excel 2007 I have been looking around for what I thought was a simple common question but I haven't found an answer. Any help would be greatly appreciated. I want have a table on Sheet1 and a table on Sheet2 in the same workbook that will have the data sync regardless of which sheet I change the data on. In other words I want to be able to change cell A5 on sheet1 and have cell c10 change on sheet2. However, I want the reverse to happen also, I want to be able to change cell c10 on sheet2 and have cell A5 on sheet1 change. I currently can only have one cell equal another with the ability to only change the original cell. Hope this makes sense.
Thank you.

**DonkeyOte** · 07-12-2009, 04:01 AM

You would need to use VBA, it would be a good idea to post a small sample file outlining which cells link to which etc... we can then post a demo for you.

**nature47** · 07-12-2009, 11:56 AM

Thank you for the suggestion. I have attached a sample file. The main sheet is "All Famers" and the second sheet is "Bob's Sale's" and you will notice that there is the same table on each titled "Bob's Weekly Sales". I would like to be able to change the data in the table on EITHER sheet and have it automatically sync up on the other sheet. Thanks for your help.

**nature47** · 07-13-2009, 02:12 AM

If there is any other information needed please let me know.

**DonkeyOte** · 07-14-2009, 05:40 AM

Sorry for delay... can I just ask... I presume you intend to have a different "sales" sheet for each "farmer" - assuming this is indeed the case will each have an identical layout ?