can you do a bi-directional link in excel
 

Excel is a pull application. You can use formulas to retrieve a value from
another cell, but you can't use a formula to push a value to another cell.

There are some macro workarounds that will allow you to update multiple cells,
but I find it safer to put the data in one spot and use formulas to grab that
value.

Mahmoud Hamed wrote:

--

Dave Peterson