richardking
New Member
- Joined
- Jan 15, 2015
- Messages
- 12
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.
<tbody>
</tbody>
Expected Results based from the data of the different websites
<tbody>
</tbody>
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.
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | ||||||||
<tbody> </tbody> |
<tbody> </tbody> | ||||||||
<tbody> </tbody> |
<tbody> </tbody> | ||||||||
<tbody>
</tbody>
Expected Results based from the data of the different websites
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody>
</tbody>