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

Similar Threads

use of ADDRESS function within CELL function 4
How to reference a cell depending on the value in another cell?? 4
If function across sheets prints value of cell 4
COUNTIF with two conditions 2
How to Populate Data from a table to another 0
Selecting a diff. worksheet but same cell references using Validat 1
if statement, change cell only if true 4
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM 3

Top