Linking Excel when inserting a line

[wyptaj]

Hi,
I have an original spreadsheet, and a new spreadsheet which is linked to the original. Therefore what ever I type into the original sheet automatically updates the new spreadsheet I've created.
However I have a problem, when an additional line is included in the original spreadsheet this doesn't filter through to the new spreadsheet.
Is there a way of getting this to work ?
Any help would be much appreciated.
Thanks

 

[hatman]

Welcome to the Board!

If I understand your situation, you effectively have a User Input sheet, and a second Output Sheet, which probably has some variation of

=A1

in cell A1, copied down and across, as needed, to duplicate the data.

If that is the case, the easy way is to instead use this formula in the Output Sheet:

=INDEX(Sheet1!$1:$65536,ROW(),COLUMN())

, and copy as needed. This should effectively "break the link" and allow the user to insert or delete rows and columns from the Input Sheet without wreaking havoc in the Output Sheet.

 

[wyptaj]

Thank you so much, that works perfectly.
Many thanks I really appreciate it.