+ Reply to Thread
Results 1 to 11 of 11

Web Query - Search a Website Using Value of Cells as Search Criteria

  1. #1
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Web Query - Search a Website Using Value of Cells as Search Criteria

    Hi Guys,

    I need help. I want to use Web Query in my Excel Sheet to show the Gross Sales of the movies that I am looking for.
    Information about the movies are in columns A and B.
    Column A contains the title, column B has the year when the movie was released.
    Column C to E will displayed the Gross Sales of these movies based on the websites: the-numbers, boxofficemojo and imdb respectively.

    How it should display the Gross Sales should be dynamic. Meaning, as the movie information in columns A and B changes, it should show the correct Gross Sales as taken from their respective websites.
    I already made a search for similar topics in this forum, but they seem to be outdated already and thus don't apply.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Hi Guys, any help?

  3. #3
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    I'm not sure exactly what you're looking for. Web Query returns XML results, but you have to know the full URL query string in order to get the info. I don't know that any of those websites return just the gross sales as the result of a search.

  4. #4
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Hi Melvosh, thank you for looking into this. I know that excel is fully capable of doing a search based on cell values as search criteria, then picking the needed information from the result of that search.
    I just dont know how.

  5. #5
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    I think the main issue is going to be ensuring the data you want is at the search URL. For example, the data you're looking for is not at boxofficemojo's search results screen, it's at the page for Captain Marvel. That URL is not intuitive. You'll likely have to know the exact URL to reliably pull data.

    You can check the instructions at this Microsoft page to get you started on how to retrieve data from a webpage with Excel.

  6. #6
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Hi Melvosh, Im afraid you are missing something.

    1. Im sorry but what you have described is entirely different from what I was looking for. Excel can perform a search through different websites, hit the search button, and get the results.
    2. I have already checked that Microsoft support page and it does not provide the answer I am looking for. Thanks for looking into it though.
    Last edited by richardking; 03-20-2019 at 01:17 AM.

  7. #7
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    I hope this is in the right section.

  8. #8
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Hi Guys, I'm trying to transfer this to the Excel Programming / VBA / Macros section of this forum.
    Last edited by richardking; 03-22-2019 at 12:00 AM.

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  10. #10
    Forum Contributor
    Join Date
    01-15-2015
    Location
    philippines
    MS-Off Ver
    Excel 365
    Posts
    116

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Sorry about that, I wanted to transfer this thread over to that section.
    Can you help with my question instead?

  11. #11
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Web Query - Search a Website Using Value of Cells as Search Criteria

    Please post all other sites you have posted to. No one will respond to your request for help until you have listed all sites you have posted this same question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 25
    Last Post: 06-10-2016, 10:17 AM
  2. VBA Macro to Search a Website's Search-Box
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2015, 02:35 PM
  3. Create User form to perform search using multiple search criteria
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 06:16 AM
  4. Replies: 4
    Last Post: 05-20-2014, 10:03 AM
  5. Replies: 1
    Last Post: 10-18-2012, 05:52 AM
  6. Replies: 0
    Last Post: 11-05-2009, 04:47 AM
  7. Link data in cells to a search on a specific website
    By gideonjav in forum Excel General
    Replies: 1
    Last Post: 10-16-2009, 12:30 PM

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