updating linked cells

[Guest]

I have a workbook with a primary worksheet and a secondary worksheet. My
primary worksheet is where I enter most of my numbers and data. My secondary
worksheet was made by copying certain items from the primary worksheet and
pasting them as a link into the secondary worksheet. It works well, I update
or change data in the primary worksheet and the secondary sheet updates. I
have problems however when I insert rows into the primary worksheet. Lets
say that I insert a row and the inserted row is row 7. In the secondary
worksheet my linked cells are still working but as I click on them and look
at the link coordinates I see that it skips from row 6 to row 8. It skips
over the row I just inserted in the primary worksheet.

Is there a way to get the secondary sheet to update when I insert (or
delete) a row from the primary worksheet?

 

[Guest]

Hi there - yes this is a common problem and you have to make sure that the
primary and secondary sheets are mirror images of eachother. The best way
around this is to build lots of blank entry rows in the primary sheets which
are already linked through to the secondary sheet. You then populate the
primary sheet as required. (you can hide them until you need them) Hope this
makes sense.