Hi,
Is it possible to input text into a cell and then a hyperlink is automatically created using a pre-defined link. For example: the user enters 1234 into any cell in column A and then cell A1 is automatically a hyperlink to address.co.uk/1234 ?
So whatever cell has text entered into it, becomes a hyperlink with that text at the end of the web address.
Impossible?
Is it possible to input text into a cell and then a hyperlink is automatically created using a pre-defined link. For example: the user enters 1234 into any cell in column A and then cell A1 is automatically a hyperlink to address.co.uk/1234 ?
So whatever cell has text entered into it, becomes a hyperlink with that text at the end of the web address.
Impossible?