hyperlink and cell contents

[newbie]

Hi,

I'm having a little trouble linking a hyperlink to the contents of a cell. The
hyperlinks seem to be attached to the cell and not the data in the cell, which
is no good seeing I have to sort my data for different circumstances.
Is there some way of making the hyperlink 'follow' the data?

Thanks,
Andrew

 

[Dave Peterson]

Maybe you could use the =hyperlink() formula.

Hi,

I'm having a little trouble linking a hyperlink to the contents of a cell. The
hyperlinks seem to be attached to the cell and not the data in the cell, which
is no good seeing I have to sort my data for different circumstances.
Is there some way of making the hyperlink 'follow' the data?

Thanks,
Andrew

 

[David McRitchie]

A similar question was posted at least a week ago, I tested
with the builtin hyperlinks and had no trouble sorting and
the links went along with he cell content when sorted, and
this was reported by one of the responders then.

Can you provide more information exactly what you have
what you selected before sorting, and how you sorted.
The sort will expand the sort area if you select a single cell.
In general it is best to select all cells before sorting which
you can do with Ctrl+A which has the advantage of not
changing your active cell.

 

[Andrew Hall]

Well, hyperlink() did the trick for sorting, but I am having another problem.

I have a large sheet with one column that looks like this:

=VLOOKUP(F3,'Item # & Description'!B$2:C$80,2,FALSE)

The table_array (!B$2:C$80') that it refers to actually has hyperlinks like
this:

=HYPERLINK("C:\...Fittings Spreadsheet\KMB1020R.jpg","KMB1020R")

How do I link the hyperlink to the vlookup function?

Thanks
Andrew

A similar question was posted at leasta week ago, I tested
with the builtin hyperlinks and had no trouble sorting and
the links went along with he cell content when sorted, and
this was reported by one of the responders then.

Can you provide more information exactly what you have
what you selected before sorting, and how you sorted.
The sort will expand the sort area if you select a single cell.
In general it is best to select all cells before sorting which
you can do with Ctrl+A which has the advantage of not
changing your active cell.

 

[Dave Peterson]

How about just using =hyperlink() once again:

=hyperlink(vlookup(F3,'Item # & Description'!B$2:C$80,2,FALSE))

But you'll have to make that friendly name a little less friendly in the
original link.

=hyperlink("c:\...\kmb1020r.jpg")

or if the folder is always the same, you can embed it in your new formula:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...))

And if you wanted the friendly name to show:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...),vlookup(...))

Well, hyperlink() did the trick for sorting, but I am having another problem.

I have a large sheet with one column that looks like this:

=VLOOKUP(F3,'Item # & Description'!B$2:C$80,2,FALSE)

The table_array (!B$2:C$80') that it refers to actually has hyperlinks like
this:

=HYPERLINK("C:\...Fittings Spreadsheet\KMB1020R.jpg","KMB1020R")

How do I link the hyperlink to the vlookup function?

Thanks
Andrew

A similar question was posted at leasta week ago, I tested
with the builtin hyperlinks and had no trouble sorting and
the links went along with he cell content when sorted, and
this was reported by one of the responders then.

Can you provide more information exactly what you have
what you selected before sorting, and how you sorted.
The sort will expand the sort area if you select a single cell.
In general it is best to select all cells before sorting which
you can do with Ctrl+A which has the advantage of not
changing your active cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: <a href="http://www.mvps.org/dmcritchie/excel/excel.htm">http://www.mvps.org/dmcritchie/excel/excel.htm</a>
Search Page: <a href="http://www.mvps.org/dmcritchie/excel/search.htm">http://www.mvps.org/dmcritchie/excel/search.htm</a>

Maybe you could use the =hyperlink() formula.



newbie wrote:

Hi,

I'm having a little trouble linking a hyperlink to the contents of a cell. The
hyperlinks seem to be attached to the cell and not the data in the cell, which
is no good seeing I have to sort my data for different circumstances.
Is there some way of making the hyperlink 'follow' the data?

Thanks,
Andrew

 

[Andrew Hall]

Thanks, that did the trick

Andrew

How about just using =hyperlink() once again:

=hyperlink(vlookup(F3,'Item # & Description'!B$2:C$80,2,FALSE))

But you'll have to make that friendly name a little less friendly in the
original link.

=hyperlink("c:\...\kmb1020r.jpg")

or if the folder is always the same, you can embed it in your new formula:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...))

And if you wanted the friendly name to show:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...),vlookup(...))

Well, hyperlink() did the trick for sorting, but I am having another problem.

I have a large sheet with one column that looks like this:

=VLOOKUP(F3,'Item # & Description'!B$2:C$80,2,FALSE)

The table_array (!B$2:C$80') that it refers to actually has hyperlinks like
this:

=HYPERLINK("C:\...Fittings Spreadsheet\KMB1020R.jpg","KMB1020R")

How do I link the hyperlink to the vlookup function?

Thanks
Andrew

A similar question was posted at leasta week ago, I tested
with the builtin hyperlinks and had no trouble sorting and
the links went along with he cell content when sorted, and
this was reported by one of the responders then.

Can you provide more information exactly what you have
what you selected before sorting, and how you sorted.
The sort will expand the sort area if you select a single cell.
In general it is best to select all cells before sorting which
you can do with Ctrl+A which has the advantage of not
changing your active cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: <a href="<a href="http://www.mvps.org/dmcritchie/excel/excel.htm">http://www.mvps.org/dmcritchie/excel/excel.htm</a>"><a href="http://www.mvps.org/dmcritchie/excel/excel.htm">http://www.mvps.org/dmcritchie/excel/excel.htm</a></a>
Search Page: <a href="<a href="http://www.mvps.org/dmcritchie/excel/search.htm">http://www.mvps.org/dmcritchie/excel/search.htm</a>"><a href="http://www.mvps.org/dmcritchie/excel/search.htm">http://www.mvps.org/dmcritchie/excel/search.htm</a></a>

Maybe you could use the =hyperlink() formula.



newbie wrote:

Hi,

I'm having a little trouble linking a hyperlink to the contents of a cell. The
hyperlinks seem to be attached to the cell and not the data in the cell, which
is no good seeing I have to sort my data for different circumstances.
Is there some way of making the hyperlink 'follow' the data?

Thanks,
Andrew