link cell in 1 wk-sht to another & keep it regardless of sorting
I am trying to link a cell ( an item price) in 1 worksheet to another
worksheet and have the correct price displayed regardless of any sorting of
data that I do. When I set up a link it works well except when I sort the
data in the worksheet 1 or 2
|