Manual input data in local excel file. I then click an adjacent image to run a preset hyperlink, to a specific web page, with part data captured from a specific cell. this is 100% possible if you click a standard hyperlink command in a cell but would like it to run from an image click.
I want to pick up the manual data input, from the cell and include this in the hyperlink reference, attached to the image.
An example or specifically:
This runs perfectly from a cell click.
I have used Concat to join the three sections together. The result is giving me ",$B$4" at the web page Of-which works perfectly if you click the containing formula cell, but I would like this to happen if I click an image.
$B$4 refers to the manual input cell specifically. An example of input string is