Thread: Removing a linked cell

Instead of the final A4 in your HYPERLINK formula, you could put any text in there, like:

...,"jump")

Hope this helps.

Pete

Thanks for the response, I did write one back but it seems to have disappeared, so don't be surprised if two appear from me.

Eventually several hundred rows will be added to this sheet, so if I remove the A4 link and add text, will that mean that it is the same text for each row rather than the specified tab?

The HYPERLINK function has two parameters - this is what you have at present:

=HYPERLINK("#'" & A4 & "'!A1", A4)

The first part (before the comma) sets up the URL where you will jump to (in this case cell A1 of the sheet whose name is in A4), and the second part after the comma is what is displayed in the cell (a friendly message). You are currently displaying the name that is in A4, which is why you see it twice - I merely suggested putting a simple text instruction in there instead.

Eventually your formula will be copied down, and it will still work in the manner that you wish, but you will still have to click on a cell in column D in order to jump to the sheet. So, you won't be able to hide column D as you won't have anything to click on, and you won't be able to hide column A as you won't be able to change any values or add any new ones.

Hope this helps.

Pet

Pete,

Thanks for that, it took me a couple of reads but I think I've got it. So am I right in thinking that I have to leave it how it is then?

Thanks

John

Well, you COULD hide column A if it is only you that puts data in, as long as you remember to unhide it again if you need to add extra data. It's a bit difficult to know how you intend to use this with only one item of data in the example file, but you will certainly need to have column D visible if you intend to jump to a particular sheet from a cell in that column.

Hope this helps.

Pete

Thanks Pete, it does answer my question and I think I'll leave the form as it is. The people is to be used by other people, so that column will just stay visible.

On the plus side, that's a whole other part of excel I just learnt!

Thanks,


John