software

hiya, i need help. what i want to do is get worksheet A to look,by name
for another worksheet and collect data to be displayed in a cell within
worksheet A......is this possible? many thanks in advance. Please bare
in mind i am a complete muppet with excel and probably shouldn´t be
attempting this so please be kind with any answers.--
c2k2
------------------------------------------------------------------------
c2k2's Profile: www.excelforum.com/member.php...oamp;userid=31676
View this thread: www.excelforum.com/showthread...hreadid=513705This formula, entered in a cell in your worksheet A, will return the value in
cell A1 of WorkSheet B........replace quot;WorkSheetBquot; with the actual name of
the other sheet.....

=WorkSheetB!A1

Vaya con Dios,
Chuck, CABGx3quot;c2k2quot; wrote:

gt;
gt; hiya, i need help. what i want to do is get worksheet A to look,by name
gt; for another worksheet and collect data to be displayed in a cell within
gt; worksheet A......is this possible? many thanks in advance. Please bare
gt; in mind i am a complete muppet with excel and probably shouldn´t be
gt; attempting this so please be kind with any answers.
gt;
gt;
gt; --
gt; c2k2
gt; ------------------------------------------------------------------------
gt; c2k2's Profile: www.excelforum.com/member.php...oamp;userid=31676
gt; View this thread: www.excelforum.com/showthread...hreadid=513705
gt;
gt;


many thanks for such a quick response i´ll give that a go--
c2k2
------------------------------------------------------------------------
c2k2's Profile: www.excelforum.com/member.php...oamp;userid=31676
View this thread: www.excelforum.com/showthread...hreadid=513705Assume your two worksheets are named Sheet 1 and Sheet 2, and you want
to get data from cell B1 of Sheet 2 and put it into cell A1 of Sheet
1. Enter this formula in cell A1 of Sheet 1:

='Sheet 2'!B1

That's all there is to it. Obviously, you should adjust the cell
references and sheet names to suit your circumstances.

Hope this helps.

PeteYou're welcome.........let us know if there's any complications.

Vaya con Dios,
Chuck, CABGx3
quot;c2k2quot; wrote:

gt;
gt; many thanks for such a quick response i´ll give that a go
gt;
gt;
gt; --
gt; c2k2
gt; ------------------------------------------------------------------------
gt; c2k2's Profile: www.excelforum.com/member.php...oamp;userid=31676
gt; View this thread: www.excelforum.com/showthread...hreadid=513705
gt;
gt;