Fetching data from another worksheet

[c2k2]

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.

 

[Guest]

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]

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

 

[Pete_UK]

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

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3