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. Macro buttons- YF, Status, O&D, DBA, and All

Problem:
1. I need a macro wherein if a value (website/company name) is entered in cell "L15", then it can be searched with the search strings mentioned in Column B and Column C.

2. For example, if I enter "site:www.google.com" or "Google, Inc." in cell "L15" and click on the "YF" macro, then the macro applies a concatenate with "L15" " " "B2". Simultaneously, the macro runs for column C "L15" " " "C2". So the 2 values which we get are:
site:www.google.com founded OR established OR began OR created OR formed OR commenced OR launched OR Inception OR started
site:www.google.com incorporated OR incorporation OR Born OR beginning OR since

OR
"Google, Inc." founded OR established OR began OR created OR formed OR commenced OR launched OR Inception OR started
"Google, Inc." incorporated OR incorporation OR Born OR beginning OR since

3. Finally, the macro executes these 2 values in separate tabs of a browser window.

4. Similarly, "Status" button executes the following link in a browser:
site:www.google.com subsidiary OR acquired OR owned OR "part of" OR division OR subsidiaries OR parent OR member OR acquisition OR acquire OR acquires OR "group company" OR holding OR owns OR umbrella OR "joint venture" OR holds OR owner

5. The macro button "All" should exceute all the functions of macro buttons at one go.

Thanks