I have a question about linking cells to a web page. I have a sheet that I would like to be able to enter a value and it would put that value on the end of a web link.
For example (its a company website so Ill use this example) If i had MrExcel that went on all values in column J and I wanted to enter a value in column J of say ABC, Im trying to make it where I click on the value in column J and it goes to https://www.mrexcel.com/ABC. It seems simple but I cant figure it out. Does anyone know how this could be done. Currently I right click on the cell and add the weblink and type the last 3 letters after the web address. Trying to automate
Thank you
Guy
For example (its a company website so Ill use this example) If i had MrExcel that went on all values in column J and I wanted to enter a value in column J of say ABC, Im trying to make it where I click on the value in column J and it goes to https://www.mrexcel.com/ABC. It seems simple but I cant figure it out. Does anyone know how this could be done. Currently I right click on the cell and add the weblink and type the last 3 letters after the web address. Trying to automate
Thank you
Guy