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: http://www.excelforum.com/member.php...o&userid=31676
View this thread: http://www.excelforum.com/showthread...hreadid=513705

This formula, entered in a cell in your worksheet A, will return the value in
cell A1 of WorkSheet B........replace "WorkSheetB" with the actual name of
the other sheet.....

=WorkSheetB!A1

Vaya con Dios,
Chuck, CABGx3


"c2k2" wrote:


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: http://www.excelforum.com/member.php...o&userid=31676
View this thread: http://www.excelforum.com/showthread...hreadid=513705

many thanks for such a quick response i´ll give that a go


--
c2k2
------------------------------------------------------------------------
c2k2's Profile: http://www.excelforum.com/member.php...o&userid=31676
View this thread: http://www.excelforum.com/showthread...hreadid=513705

Assume 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.

Pete

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

Vaya con Dios,
Chuck, CABGx3



"c2k2" wrote:


many thanks for such a quick response i´ll give that a go


--
c2k2
------------------------------------------------------------------------
c2k2's Profile: http://www.excelforum.com/member.php...o&userid=31676
View this thread: http://www.excelforum.com/showthread...hreadid=513705