Thanks Gary. This works great.

just an observation, the correct syntax is =INDIRECT("'Sheet1'!B6")

"Gary''s Student" escreveu:

=INDIRECT("Sheet1!B6")

--
Gary''s Student - gsnu200827


"LefepeCalambau" wrote:

I have a cell(B6) in sheet1 with a value anda I want to show this value in a
cell(C6) in sheet2.
What I do was:
in the cell(C6) in sheet2 I put: ='sheet1'!B6

This worked, but if I insert a line upper the line 6 in the sheet1, the
function goes like this: ='sheet1'!B7

Anyone can help me?