Anyone can help for opening multiple urls in same row of Excel sheet by triggering?
I wonder if you uploaded image case be seen.
I will explain my wish any way in case image is not visible.
Let's assume date stored in excel sheet as follow
Do you mean hot key? I prefer Option+W if I have understood correctly.
In excel sheet, there will more more than 1000 lines of link date.
Thus, first action is to locate column A to match with data(e.g. REF01) in system clipboard and open urls in same row,
Many thanks for quick answer and help.
Do you think this can be implemented on KM by your gut feeling?
Many thanks always and the macro you provide works prefectly.
Practically, I have a other data cell in between the links like attached.
To see the link more efficiently, I need to open ecah of line in new Chrome window.
Aftet O colume, there will be 20 more data cell in each row.
Would this also possible?
As a rule of thumb, always post a complete real-world data set in your first post, not an oversimplified abstraction.
Similar here, post your real requirements in the first post. Creating a new Chrome window for every row is quite different from “open three links in Col B,C and D in either safari or Chrome” as you demanded in your OP.
In this case you really should upload a complete example sheet (as .zip), in addition to the screenshot.
To upload a file, just drag it from the Finder into the forum editor window.
Attached is complete example sheet. I will store three links in each row in attached file and would like to open three links at the same time in different browser or tab by triggering hot key from column A in relevant row. The links to be opened in browser is column J, AA and AD.
It can be more in the future if something need more.
I will need 2-3 monitors to see at the same time to save clicking and seeing different data.
I ran your code last time, and it worked. But there was no data column in between links.
Please help! I am being interested in KM more and more. Why people are noting using this kind of amazing tool. Thanks in advance for help.