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