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
 
You must log in or register to reply here.

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

Copy Data from One sheet to Different Sheets 1
making cells uncopyable 1
execl lookup 1
Scatter plot / Data from matrices? 1
copy data and formulas from another worksheet 2
Displaying a range based on a cell's contents 3
Auto Complete Name 10
Display zero in the cells with Excel 2013 5

Back
Top