+ Reply to Thread
Results 1 to 5 of 5

Fetching data from another worksheet

  1. #1
    Registered User
    Join Date
    02-17-2006
    Posts
    2

    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.

  2. #2
    CLR
    Guest

    RE: Fetching data from another worksheet

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


  3. #3
    Registered User
    Join Date
    02-17-2006
    Posts
    2
    many thanks for such a quick response i┤ll give that a go

  4. #4
    Pete_UK
    Guest

    Re: Fetching data from another worksheet

    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


  5. #5
    CLR
    Guest

    Re: Fetching data from another worksheet

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1