Calling data from another excel spreadsheet...
 

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.


--
renderingsanity
------------------------------------------------------------------------
renderingsanity's Profile: http://www.excelforum.com/member.php...o&userid=32931
View this thread: http://www.excelforum.com/showthread...hreadid=527713

Calling data from another excel spreadsheet...
 

A1: 'Please use your full name in newsgroups
B1: =A1
C1: ='another sheet'!A1
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"renderingsanity" wrote:
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.

Calling data from another excel spreadsheet...
 

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.

"renderingsanity" wrote:


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.


--
renderingsanity
------------------------------------------------------------------------
renderingsanity's Profile: http://www.excelforum.com/member.php...o&userid=32931
View this thread: http://www.excelforum.com/showthread...hreadid=527713