Adding a row in a linked worksheet

  • Thread starter Thread starter keith264
  • Start date Start date
K

keith264

How can I add a row in a source worksheet while maintaining existing links to
secondary docs.

ie cells E56 - H 56 are linked to a cells in a different worksheet. I add a
new row of data & E56-H56 become new E57-H57. In the linked sheets the data
changes to the new E56-H56. I want it to continue to link to the data that
was in the original cells.
 
Direct links will update, as you've already discovered. So you'll have to use
INDIRECT references to keep that from happening.

=INDIRECT("Sheet2!E56")-INDIRECT("Sheet2!H56")
 
Direct links will update, as you've already discovered. So you'll have to use
INDIRECT references to keep that from happening.

=INDIRECT("Sheet2!E56")-INDIRECT("Sheet2!H56")
 

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

Similar Threads

Match worksheet Function displays wrong data on calculation 1
HYPERLINK Worksheet Function 3
Copy & paste macro for multiple worksheets 8
Sorting non-linked cells in a linked worksheet 1
Dynamic Hyperlink 4
Linking worksheets, rearranging rows. 1
Copy/Fill Down in increments 1
How do I create a hyperlink to a cell with the hyperlink function 2

Back
Top