Hyperlinks and Sorting

E

Erik

This is a repost of a previous question that didn't get an answer--Anybody
have any ideas?

Thanks in advance,

Erik
 
G

Gary76

How does the Hyperlink get into the cell? Are you using teh HYPERLINK Function?

Gary
 
E

Erik

Yes, I'm manually adding the hyperlink to the cell but am then prevented from
sorting the data without the hyperlink staying with the correct data.

E.
 
D

Dave Peterson

I think Gary76's question was really:

Are you using the worksheet function =hyperlink()?

But you're not. You're using Insert|Link.

Have you thought of using another column and =hyperlink()? Then when you sort,
you won't have a problem--well, make sure you include that other column in the
sort range, too.
 
E

Erik

Ok, I'll try that. Thanks!

Erik


Dave Peterson said:
I think Gary76's question was really:

Are you using the worksheet function =hyperlink()?

But you're not. You're using Insert|Link.

Have you thought of using another column and =hyperlink()? Then when you sort,
you won't have a problem--well, make sure you include that other column in the
sort range, too.
 
Top