Hi,
Can anyone please look into this VBA code and help me tweak it a bit in order to accommodate the changed design.
I have attached 2 files:
Source List Demo- file already having a working VBA code
Source List New- file in which I want to edit the VBA code and run it as per new design
Source List Demo file design:
The file contains the main worksheet "Launch" which contains a drop-down in cell D3 and on selecting a country, all the web-links stored in the worksheet of that country open in a browser. For example if we select Australia, all web-links in worksheet "Australia" open in a browser.
There is a separate worksheet available for each and every country and VBA works on this design.
Source List New file design:
The main worksheet "Launch" remains the same but instead of web-links being stored in separate worksheets, a single "Summary" worksheet is created.
This worksheet contains 'Country Names' in first column and web-links in subsequent columns.
Query:
Can you please help me tweak the VBA code applied to "Source List Demo" file in a way that it applies to the new design in "Source List New" file. The objective remains the same- "On selecting a country drop-down, the VBA should open all web-links of that country in a browser window." All these web-links are now stored in a single "Summary" sheet.
Thanks
Bookmarks