Use of 'INDIRECT
Use
=Sheet1!A4
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"LN" wrote in message ...
| Hi
|
| I have a workbook that contains a master price list that feeds other
| worksheets within the same work book.
|
| I used the following formula: =INDIRECT("Sheet1!A4")
| Currently Sheet 1, Cell A4 is = 100
| If I insert a row making A4 = 109, my other worksheets update to 109
|
| I need them tied to what is now A5.
|
| Can anyone please let me know if I'm using the correct formula?
| Thank you!!!!
|