Stop linked cells from changing when insert new row?

  • Thread starter Thread starter gorvic
  • Start date Start date
G

gorvic

difficult to explain but here goes. I have a master workbook and have linked
(copy>paste special>paste 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.
 
In the Master WS, try to declare NAMES to ranges/cells who are linked.
Micky


והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"
 
Back
Top