Fetching data from another worksheet

  • Thread starter Thread starter c2k2
  • Start date Start date
C

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.
 
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
 
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
 
Back
Top