Hyperlinks and Sorting

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

Thanks in advance,

Erik

---------------------------------------------------------------------------------------
I have a column of data in which each entry is a hyperlink. When I sort the
data, the hyperlink stays in the cell and the text is sorted, so the text in
the new cells doesn't match the hyperlink
---------------------------------------------------------------------------------------

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

Gary

"Erik" wrote:

> This is a repost of a previous question that didn't get an answer--Anybody
> have any ideas?
>
> Thanks in advance,
>
> Erik
>
> ---------------------------------------------------------------------------------------
> I have a column of data in which each entry is a hyperlink. When I sort the
> data, the hyperlink stays in the cell and the text is sorted, so the text in
> the new cells doesn't match the hyperlink
> ---------------------------------------------------------------------------------------

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.



"Gary76" wrote:

> How does the Hyperlink get into the cell? Are you using teh HYPERLINK Function?
>
> Gary
>
> "Erik" wrote:
>
> > This is a repost of a previous question that didn't get an answer--Anybody
> > have any ideas?
> >
> > Thanks in advance,
> >
> > Erik
> >
> > ---------------------------------------------------------------------------------------
> > I have a column of data in which each entry is a hyperlink. When I sort the
> > data, the hyperlink stays in the cell and the text is sorted, so the text in
> > the new cells doesn't match the hyperlink
> > ---------------------------------------------------------------------------------------

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.

Erik wrote:
>
> 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.
>
> "Gary76" wrote:
>
> > How does the Hyperlink get into the cell? Are you using teh HYPERLINK Function?
> >
> > Gary
> >
> > "Erik" wrote:
> >
> > > This is a repost of a previous question that didn't get an answer--Anybody
> > > have any ideas?
> > >
> > > Thanks in advance,
> > >
> > > Erik
> > >
> > > ---------------------------------------------------------------------------------------
> > > I have a column of data in which each entry is a hyperlink. When I sort the
> > > data, the hyperlink stays in the cell and the text is sorted, so the text in
> > > the new cells doesn't match the hyperlink
> > > ---------------------------------------------------------------------------------------

--

Dave Peterson

Ok, I'll try that. Thanks!

Erik


"Dave Peterson" wrote:

> 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.
>
> Erik wrote:
> >
> > 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.
> >
> > "Gary76" wrote:
> >
> > > How does the Hyperlink get into the cell? Are you using teh HYPERLINK Function?
> > >
> > > Gary
> > >
> > > "Erik" wrote:
> > >
> > > > This is a repost of a previous question that didn't get an answer--Anybody
> > > > have any ideas?
> > > >
> > > > Thanks in advance,
> > > >
> > > > Erik
> > > >
> > > > ---------------------------------------------------------------------------------------
> > > > I have a column of data in which each entry is a hyperlink. When I sort the
> > > > data, the hyperlink stays in the cell and the text is sorted, so the text in
> > > > the new cells doesn't match the hyperlink
> > > > ---------------------------------------------------------------------------------------
>
> --
>
> Dave Peterson
>