Looking for a Macro to Get Data from Website

**ashokpatidar** · 08-10-2013, 09:53 PM

Hi All,

I am looking for a Macro that can get the specific data from Web.

I have thousands of keywords in Columns A of a sheet. Now, i want each of the keyword from Column A to search on a particular website's search button and then paste just H3 tag data from the search result into column B. The website where i have to search the keywords and check whether right result is appearing or not , is a common website for all keywords.

Can anyone spare a minute on this and write the Macro for me?

**shyamhappy** · 08-10-2013, 10:18 PM

Please provide me the Website details and the Workbook of keywords.

_____________________________________________________________________________________________________________________________________________
if you feel something has helped please click * to add to reputation

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison

**ashokpatidar** · 08-10-2013, 11:17 PM

Originally Posted by shyamhappy

Please provide me the Website details and the Workbook of keywords.

_____________________________________________________________________________________________________________________________________________
if you feel something has helped please click * to add to reputation

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison

Hi,

Thank you for responding.

The website name is http://www.eastbay.com and a couple of Keywords are:

football cleats
football kicker shoes
football pads
Etc.

Here is the Excel Workbook Screenshot:

1.jpg

Once again thanks for your interest on my issue.