Open Hyperlinks in a Browser

[bilkar1985]

Hello,

for now, in the excel file provided, I click manually on the hyperlink in column D to open it in a browser and put in the values on my own.

I want to be able to open the hyperlinks with a button click automatically in different browser tabs and retrieve values found in google search results in a specific column (B). Optional should be to delete values in column C that exceed value 250 and values in column D that exceed value 0.500, while colouring those that are less than 0.250 in value at the same time.

I attach the excel file.

Thank you in advance,
VK

 

[saurabhjaina211]

Hi VK,

Please clarify -
Seems you would like to scrape values from given websites.

1. AIT value is search result.
2. From where you are getting SV?
3. Ratio is AIT/ SV

Thanks,
Saurabh

 

[bilkar1985]

I want to scrape google result values.

1. AIT is google search result
2. SV is search volume, I get it from another excel worsheet
3. That is correct

Thanks,
VK