Hi
Can anyone tell me whether there is a way to automatically hyperlink a given cell within a column to a new worksheet in the same book named the same as the data in the cell?
For example;
If the data in column A of Sheet 1 is:
A1 = 1
B1 = 2
C1 = 3
D1 = 4
and so on,
and I then create a new worksheet named 1, is there a way of automatically making Sheet 1 Cell A1 Hyperlink to that new sheet?
I would need the solution to be recurring so that any cell in the selected column links to the newly created worksheet of the same name.
I guess it will need to be done in VBA, but I am not techy enough to do this myself.
Any help would be greatly appreciated.
Thanks,
James.
Can anyone tell me whether there is a way to automatically hyperlink a given cell within a column to a new worksheet in the same book named the same as the data in the cell?
For example;
If the data in column A of Sheet 1 is:
A1 = 1
B1 = 2
C1 = 3
D1 = 4
and so on,
and I then create a new worksheet named 1, is there a way of automatically making Sheet 1 Cell A1 Hyperlink to that new sheet?
I would need the solution to be recurring so that any cell in the selected column links to the newly created worksheet of the same name.
I guess it will need to be done in VBA, but I am not techy enough to do this myself.
Any help would be greatly appreciated.
Thanks,
James.
