Is there a way to create a two way link? By this I mean create a link that no matter which sheet I am on it will update both sheets. Right now I can create the link and I can only make changes on one sheet and the other sheet only sees tthe change.
Not likely. It would create a circular reference.
Even in many spreadsheet packages, this would require custom code.
