VBA to automate site-search and Google search

[Kavish Sekhri]

Hi,

Can anyone help me in writing a macro for this?

Problem- To automate site-search or google search in an excel sheet.

Please refer to the sheet attached for the problem, explanation for which is as follows:

Sheet contains the following elements:
1. Search Strings- keywords to search on Google or a particular website.
2. Field for entering web url/company name (L15)
3. Column D- Concatenate (B2, " ", L15)
4. Column E- Concatenate (C2, " ", L15)
3. Macro buttons- YF, Status, O&D, DBA, and All

Problem:

Using VBA, I want to copy values in Column D and E and launch them in a browser window on clicking a macro button.

For example, when I click on macro button "YF" all values corresponding to search string category YF (D2 and E2) gets copied and open in 2 tabs of a browser window.
Macro should copy and search the following text in a browser window:
Tab 1- site:paytm.com founded OR established OR began OR created OR formed OR commenced OR launched OR Inception OR started

Tab 2- site:paytm.com incorporated OR incorporation OR Born OR beginning OR since

Similarly, clicking on macro button "Status" copies D3 and E3 and opens them in separate tabs of a browser window.

Finally, clicking on macro button "All" copies all values in Column D and E and opens them in a browser window in separate tabs.

Thanks in advance.