Stop linked cells from changing when insert new row?
 

difficult to explain but here goes. I have a master workbook and have linked
(copypaste specialpaste link) cells from it to create several worksheets -
these worksheets have completely different formatting than the master.

My problem is that when i need to insert or delete a row from the master the
linked worksheets get jumbled - is there a way i can insert a new row into
the master without changing the locations of the linked cells in the other
worksheets?

Not really sure if it can be done but thoght i'd try.

Stop linked cells from changing when insert new row?
 

In the Master WS, try to declare NAMES to ranges/cells who are linked.
Micky


והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"gorvic" wrote:

difficult to explain but here goes. I have a master workbook and have linked
(copypaste specialpaste link) cells from it to create several worksheets -
these worksheets have completely different formatting than the master.

My problem is that when i need to insert or delete a row from the master the
linked worksheets get jumbled - is there a way i can insert a new row into
the master without changing the locations of the linked cells in the other
worksheets?

Not really sure if it can be done but thoght i'd try.