Thread: Fetching data from another worksheet

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.

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

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