Stop linked cells from changing when insert new row?


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.
 
Ad

Advertisements

×

מיכ×ל (מיקי) ×בידן

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


והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[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

Top