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