+ Reply to Thread
Results 1 to 11 of 11

Formula to pull data from another spreadhseet

  1. #1
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Formula to pull data from another spreadhseet

    Hi,

    Does anyone know a formula I can use that will pull data from Test2.xls and put it into the appropriate cells of Test1.xls. I have completed worksheet AAA to show what I'm after...

    Thanks

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Formula to pull data from another spreadhseet

    Hi eoghanmolloy,

    Try using below formula;-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    test.zip

    Enter formula using ctrl shift enter key combination.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Formula to pull data from another spreadhseet

    Hi DILIPandey,

    I must be doing something stupid here. I've inserted your formula into Test1.xls and pressed Ctrl, Shift and Enter but nothing seems to be happening...

  4. #4
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Formula to pull data from another spreadhseet

    It might be something to do with me using Excel 2003??

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Formula to pull data from another spreadhseet

    may be .. if error function will not work in 2003, try below one :-
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    confirm with Ctrl shift enter

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  6. #6
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Formula to pull data from another spreadhseet

    Each cell is now apearing with '################'??

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Formula to pull data from another spreadhseet

    okay.. upload your sample workbook.. thanks.

    I hope you are using correct references as per formula requirement as in my workbook

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  8. #8
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Formula to pull data from another spreadhseet

    Here is Test1.xls

  9. #9
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Formula to pull data from another spreadhseet

    Hi DILIPandey,

    Have you had a chance to look at my problem?

  10. #10
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Formula to pull data from another spreadhseet

    yes... your formula cells are formatted as Text. Change the format to General and try again. thanks.

    for more information, see the zip file which uploaded earlier.. and try matching the cell format.. in case of any issues, upload your BOTH workbooks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  11. #11
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Formula to pull data from another spreadhseet

    Thank you...working perfectly now!

  12. #12
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Formula to pull data from another spreadhseet

    you are welcome eoghanmolloy..

    Cheers

    Regards,
    DILIPandey
    <click on below 'star' if this helps>

+ 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