Kavish Sekhri
New Member
Can someone please check the following sheet and help me with the VBA for this? Please check the sheet attached and query is as follows:
Query:
I work on data wherein I fill a CompanyID in excel (Column-A) and use plug-in to extract Company Name (Column C) and Country (Column D).
Then, I apply Hyperlink along with Vlookup (in Column E and F) to lookup Country (Column D) value in Sheet 2-Column B and C respectively.
After this I need a macro wherein I can open all the hyperlinks of a particular country to open in a single browser window.
Example:
Value in cell D2- Belgium
Please suggest a macro to open all the hyperlinks in E2, F2, and so on in a browser window....
Note: The formula in E2 and F2 are as follows
E2- =HYPERLINK(VLOOKUP(D2,Sheet2!A:B,2,0))
F2- =HYPERLINK(VLOOKUP(D2,Sheet2!A:C,3,0))
Thanks
Kavish
Query:
I work on data wherein I fill a CompanyID in excel (Column-A) and use plug-in to extract Company Name (Column C) and Country (Column D).
Then, I apply Hyperlink along with Vlookup (in Column E and F) to lookup Country (Column D) value in Sheet 2-Column B and C respectively.
After this I need a macro wherein I can open all the hyperlinks of a particular country to open in a single browser window.
Example:
Value in cell D2- Belgium
Please suggest a macro to open all the hyperlinks in E2, F2, and so on in a browser window....
Note: The formula in E2 and F2 are as follows
E2- =HYPERLINK(VLOOKUP(D2,Sheet2!A:B,2,0))
F2- =HYPERLINK(VLOOKUP(D2,Sheet2!A:C,3,0))
Thanks
Kavish