Linked Worksheets

[Robert Lee]

Dear All

I have looked through the FAQs etc without success so would appreciate
any help.

Use Sheet 1 for data input.

Sheet 1 cells A1 and A2 are populated with a Text entry, for example.

Sht1A1 TOP
Sht1A2 BOTTOM

Sheet 2 Cells A1 and A2 point at their corresponding cells on sheet 1.

Now INSERT a new row on Sheet 1 between A1 and A2 and add text thus:-

Sht1A1 TOP
Sht1A2 MIDDLE
Sht1A3 BOTTOM

OK, so Sheet 2 remains unchanged. I want it to change so that it reads
the same as Sheet 1. How?

The purpose of my query is to enable other sheets in my workbook to
remain focussed on their respective purpose and easy for other users to
understand.

Many thanks in advance
Robert

 

[Peo Sjoblom]

Use indirect

=INDIRECT("Sheet1!A1")

You can prepare and just fill in the formulas in sheet2 copy down and use
something like


=IF(INDIRECT("Sheet1!A1")="","",INDIRECT("Sheet1!A1"))

and so on

 

[Robert Lee]

Thank you very much Peo.
It works a treat.
Robert