Hi there!
I'm looking to find a way of using a cell's contents as part of a dynamic hyperlink. Eg. if i had lots of different code numbers in a column, and I wished to load the page "www.examplesite.com/code.php?code=XXXX" where XXXX was the content of an adjacent cell, how would I go about doing this, if it is even possible at all?
I.e. if I had the following spreadsheet:
A1 = "01" and B1 = "Click here to launch page 01"
A2 = "02" and B2 = "Click here to launch page 02"
A3 = "03" and B3 = "Click here to launch page 03"
You could see how the cells in column B would benefit from a "dynamic URL" whereby the url could specify that code.php?code=A1 or A2 or A3.
Sorry if this is hard to understand, and MANY thanks for any answers.
I'm looking to find a way of using a cell's contents as part of a dynamic hyperlink. Eg. if i had lots of different code numbers in a column, and I wished to load the page "www.examplesite.com/code.php?code=XXXX" where XXXX was the content of an adjacent cell, how would I go about doing this, if it is even possible at all?
I.e. if I had the following spreadsheet:
A1 = "01" and B1 = "Click here to launch page 01"
A2 = "02" and B2 = "Click here to launch page 02"
A3 = "03" and B3 = "Click here to launch page 03"
You could see how the cells in column B would benefit from a "dynamic URL" whereby the url could specify that code.php?code=A1 or A2 or A3.
Sorry if this is hard to understand, and MANY thanks for any answers.