Software

Ask something
Question Locked

How to inherit changes from linked worksheet?

0 helpful
3 replies

by esther.fong

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I have 2 worksheet in an excel workbook. The second worksheet is linked to the first worksheet.
Periodically I need to insert/delete rows in the first worksheet. Ideally when this happens I would like the second worksheet to reflect this automatically.
Is this possible in Excel?

Thanks for any help.

cheers
Stable

3 replies

by thumbsup2

The 2nd worksheet will reflect the changed cell references when things are added/deleted in the first spreadsheet. However, it will not insert/remove entire rows.

by esther.fong

Thanks ThumbsUp2.

The first worksheet contains a list of GL Codes and descriptions.
The second worksheet uses these GL Codes and has extra columns for inputting actual data, budgets and other calculated formulae.
The reason for 2 separate worksheet is so that 3rd and subsequent worksheets may be added using the GL codes on the 1st worksheet as "drivers". As GL Codes are added/deleted - the change needs to be reflected in the other worksheets.

Any ideas on how I can achieve this?

Cheers
Stable

This discussion is closed to new replies.