D
Don Bishop
In one worknook, I have 2 sheets, a master and subsidiary.
I copy a portion of the master and paste to the subsidiary.
I want the formulas I copied to the subsidiary to change
when I change the corresponding master cell.
I did paste special (pastelink), which works fine as long
as I don't resort the master. When I resort the master,
the subsidiary cell now takes on a new value according to
how I sorted the master.
How do I ensure that no matter where I put the master cell
in the master sheet, it post correctly to the
corresponding item in the subsidiary.
I copy a portion of the master and paste to the subsidiary.
I want the formulas I copied to the subsidiary to change
when I change the corresponding master cell.
I did paste special (pastelink), which works fine as long
as I don't resort the master. When I resort the master,
the subsidiary cell now takes on a new value according to
how I sorted the master.
How do I ensure that no matter where I put the master cell
in the master sheet, it post correctly to the
corresponding item in the subsidiary.