+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 22

Pulling information from another workbook

  1. #1
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Pulling information from another workbook

    Hello,

    I am here looking for advice as to what the best thing to do with my problem.
    The problem itself is that I have a drop down box with a large list of companies.
    The requirement is that when one of these companies is selected the company information will appear in a couple of other cells below that drop down box. The data is in another workbook. I looked at an IF function that said if this company is in the box then display its information in this cell, but I can't put more than seven nested if statements in one cell.
    So my question is this a VBA solvable problem or is there another function I can use?

    Thanks you

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,799

    Re: Pulling information from another workbook

    You could use a lookup table.

    If you want specific advice, then provide sample workbooks.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling information from another sheet

    I must apologise I meant a different sheet

    but here is an example of my problem as the data is private

    I can't find go advanced

  4. #4
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling information from another workbook

    I found it but doesn't seem to be working

    Basically in one sheet (sheet1) I have a drop down list with 6 lines of data in:

    Gigantic Company
    Huge Company
    Big Company
    Medium Company
    Small Company
    Tiny Company

    Below that I have a cell which will have the data in.

    Then in another sheet (sheet2) I have the data for each company

    So how do I pull that data in to that single cell in sheet 1?

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,799

    Re: Pulling information from another workbook

    Please read what I said before:

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Go Advanced is bottom right in the edit post window.

  6. #6
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling information from another workbook

    I tried doing what you said and it still doesn't allow me to attach a file.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,799

    Re: Pulling information from another workbook

    What error message are you getting?

  8. #8
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling information from another workbook

    I go through the 'Go Advanced' link, then to the 'Manage Attachments' link and there are no instructions, just the standard manage attachments page, which doesn't work

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,799

    Re: Pulling information from another workbook

    At the top there is an upload dialog - you need to browse to the file on your computer and add it there, then click on upload, then save.

  10. #10
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    Re: Pulling information from another workbook



    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  11. #11
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling information from another workbook

    I choose a file to upload, I then click upload and I get an error message saying 'Please select a file to upload'
    I will try from a personal device

  12. #12
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28
    My personal device seems to have worked
    Attached Files Attached Files

  13. #13
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    Cool Re: Pulling information from another workbook

    Is that what you want?
    but with this example and to see how it works you'll need PowerQuery and macro enabled workbook

  14. #14
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    Re: Pulling information from another workbook

    Sandy powerquery will work great if eventually you still want to pull out even more information.

    If it is just pulling out Sheet2 column C data, maybe you can look at vlookup or index match to retrieve the data.

    Under Sheet1 D5, try insert this =IFERROR(INDEX(Sheet2!C:C,MATCH(Sheet1!D3,Sheet2!B:B,0)),"")

  15. #15
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling information from another workbook

    The actual data set is around 60 entries, so what would be the best approach?

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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