software

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: www.excelforum.com/member.php...oamp;userid=32931
View this thread: www.excelforum.com/showthread...hreadid=527713A1: '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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;renderingsanityquot; wrote:
gt; I want to call a column or a row from another excel spreadsheet. I am
gt; sure this has been posted before but I don't know what you'd call it so
gt; I don't know what to search for.
Have both worksheets open. Put your cursor in the cell where you want the
value to be sent to. Click on the quot;equalsquot; 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.

quot;renderingsanityquot; wrote:

gt;
gt; I want to call a column or a row from another excel spreadsheet. I am
gt; sure this has been posted before but I don't know what you'd call it so
gt; I don't know what to search for.
gt;
gt;
gt; --
gt; renderingsanity
gt; ------------------------------------------------------------------------
gt; renderingsanity's Profile: www.excelforum.com/member.php...oamp;userid=32931
gt; View this thread: www.excelforum.com/showthread...hreadid=527713
gt;
gt;