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?