Link Cells - Anyway to update data on either sheet

I use the cell linking extensively, however it would be so very helpful if cells could be updated from either sheet... For example, I have a master project sheet that consolidates lines from mulitple projects in sepearte sheets. However when I want to make a change to one of the lines I have to go to that projects sheet rather than being able to update from the master sheet. Not all users of the individual sheets need or should have access to the master sheet so I don't want the data to "start" in the master sheet either. Thoughts?????

Thanks,
Lacy

Find more posts tagged with

Cell linking

Enhancement Request

Comments

J. Craig Williams

Lacy,

The link is one-way.

You can follow the link from the cell on the master sheet but that does not save much time.

Craig

Kennedy Stomps

Hi Lacy-- I've added your vote for two-way cell linking to our enhancement request list. We appreciate your input!

R.Silber

Would LOVE this feature! Or, if I could, with one or two clicks, change the direction of the linkage, that'd work too.