Stop linked cells from changing when insert new row?



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

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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question