Display data from other sheet

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
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
 
Back
Top