Locked in

[smandula]

How do you lock in a formula that receives data from Sheet 1?

Sheet1!$B$8

Every time I add a new line to Sheet1 the data moves down,
So does the formula.

Sheet1!$B$9

I thought $ would freeze the cell reference.

Any thoughts?

[mangesh_yadav]

Use this instead:
=INDIRECT("Sheet1!B8")

Mangesh

[smandula]

I guess the idirect function may the answer.
=INDIRECT("Sheet1!A1")

Anything further?