+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 22 of 22

Pulling information from another workbook

  1. #16
    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

    60 columns or 60 rows?
    doesn't matter - you can use PowerQuery as well
    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

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

    Re: Pulling information from another workbook

    So say what I had in sheet2 Gigantic Company - 10000
    Huge Company - 5000
    etc
    I have 60 rows of data like that

  3. #18
    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

    and where is the problem?

    attach representative example excel file

  4. #19
    Registered User
    Join Date
    02-13-2018
    Location
    England
    MS-Off Ver
    2013
    Posts
    28
    So here is another example of my data. In all on sheet two i have around 60 entries.

    On sheet one i have a dropdown box with those companies on sheet 2 listed.

    When a user selects a company from that list, the the cell highlighted on sheet one, the data for that company would appear from sheet two

    And is there a way of doing it without powerquery?
    Thank you
    Attached Files Attached Files

  5. #20
    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

    ok, here is an example with 100 companies and values
    with duplicates or not
    selected company in PivotTable will be highlighted on the list - sheet1

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

    Re: Pulling information from another workbook

    Just wanted to say I solved the issue with an index match function, I suppose VLookup would have worked too.

    With theses functions I was able to keep my design.

    Much appreciated for all your help!

  7. #22
    Registered User
    Join Date
    02-17-2018
    Location
    Bowling Green, KY
    MS-Off Ver
    Office 2010
    Posts
    6

    Re: Pulling information from another workbook

    I'm not sure if you have found your answer or not but I am currently doing something very similar to this. I used the vlookup function to have it pull the name of the company, the contact, address and phone number to certain cells when I selected a certain city. My equation looked like this:
    =VLOOKUP(H7,LOCATIONS2!A1:F7,1,False)
    Basically H7 had the city I wanted to equation to reference, LOCATIONS2! is the worksheet & A1:F7 is the table array, 1 is the column it will find the answer in, False prevents anything that doesn't match 100% from being pulled over.
    Like I said, this may not work for you but it works for me when I'm needing to pull their mailing info over for each city I select.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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