Calling data from another excel spreadsheet...

R

renderingsanity

I want to call a column or a row from another excel spreadsheet. I am
sure this has been posted before but I don't know what you'd call it so
I don't know what to search for.
 
D

David McRitchie

A1: 'Please use your full name in newsgroups
B1: =A1
C1: ='another sheet'!A1
 
C

Caseybay

Have both worksheets open. Put your cursor in the cell where you want the
value to be sent to. Click on the "equals" sign. The cell will be outlined by
a broken line. Now go to the cell you want it to pull from and click on it.
Voila! The first cell should have the value in it. Now you can copy the first
cell if you need to do a whole column like that.
 
Top