Display data from other sheet

S

Steve

Really simple one - bit new to excel!!

All I want to do is display what is in cell A1 worksheet 1 in cell b1
worksheet 2.

Cheers
 
C

carlo

No problem.

Type following formula in cell b1 in worksheet 2

=sheet1!a1

where you have to change "sheet1" with your
sheetname.
if there is a space in your sheetname you have
to put the name between ':

='my sheet'!a1

hth

Carlo
 
Top