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.