Auto-Update Linked Data

[antonyx]

Hello.

I have a excel spreadsheet with two worksheets; Sheet1 and Sheet2

I create a single column in Sheet1 with the following values:

1
2
3
4
5

I then highlight those values and paste them as a 'Link' onto Sheet2.

In Sheet1, if I change the value 1 to 1a, this change is reflected in Sheet2 (which is linked).

However, if I add a row in Sheet1 (perhaps in between the current values) eg:

Sheet1

1
2
3
3a
4
5

The adding of the row is not reflected in Sheet2, only the linked cells are updated.

Is there a way to ensure that any changes to the entire column are reflected between sheets using linked cells?

Thanks

[antonyx]

I should add it should also be the case that when rows are 'removed' from sheet1, they should be removed from sheet2 also.

Sheet2 should basically mirror what is on Sheet1.

[antonyx]

Hi, I've discovered that I can just group worksheets.

As long as the columns are similar in both sheets I highlight both sheets, make amendmants and they are reflected on all the grouped sheets.

Thanks