tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Down column J I have data, and some of that data are websites
I'd like a macro that can go down the column and if an address is a website create a hyperlink to that website.
if it easyier then it can do it to all cells in column J that are not blank or contain the words "Sales and marketing" or "Home and Away" (full celll values) as these are the only other data a cell might contain than a web address.
Please help if you can
Thanks
Tony
Down column J I have data, and some of that data are websites
I'd like a macro that can go down the column and if an address is a website create a hyperlink to that website.
if it easyier then it can do it to all cells in column J that are not blank or contain the words "Sales and marketing" or "Home and Away" (full celll values) as these are the only other data a cell might contain than a web address.
Please help if you can
Thanks
Tony