Show in a Cell the Value for another Cell


L

LefepeCalambau

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?
 
Ad

Advertisements

Ad

Advertisements

L

LefepeCalambau

Thanks Gary. This works great.

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

"Gary''s Student" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top