I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

Maybe you can dump the Insert|Hyperlink and replace them with the =hyperlink()
worksheet function (in an adjacent column).

If you have

in A1

Then you could use:
=hyperlink("mailto:"&a1,"Click me")
or
=hyperlink("mailto:"&a1,a1)
(and hide column A if you want)



Dave S. wrote:

I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

--

Dave Peterson

Dave,
Thanks for the recommendation, but when I tried it, I could not fill down.
I have 18 different e-mail address, but they cover over 800 locaitons. I
can't really type each address individually. Is their anyway to use the edit
fill down?

ds

"Dave Peterson" wrote:

Maybe you can dump the Insert|Hyperlink and replace them with the =hyperlink()
worksheet function (in an adjacent column).

If you have

in A1

Then you could use:
=hyperlink("mailto:"&a1,"Click me")
or
=hyperlink("mailto:"&a1,a1)
(and hide column A if you want)



Dave S. wrote:

I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

--

Dave Peterson

Maybe you can explain why fill down didn't work?

Just a guess--did you have the data filtered?

Dave S. wrote:

Dave,
Thanks for the recommendation, but when I tried it, I could not fill down.
I have 18 different e-mail address, but they cover over 800 locaitons. I
can't really type each address individually. Is their anyway to use the edit
fill down?

ds

"Dave Peterson" wrote:

Maybe you can dump the Insert|Hyperlink and replace them with the =hyperlink()
worksheet function (in an adjacent column).

If you have

in A1

Then you could use:
=hyperlink("mailto:"&a1,"Click me")
or
=hyperlink("mailto:"&a1,a1)
(and hide column A if you want)



Dave S. wrote:

I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

--

Dave Peterson


--

Dave Peterson

I was able to do the fill down, but the adddresses still didn't move when I
re-sorted. I'll try your way again. I must have done something wrong.
ds

"Dave Peterson" wrote:

Maybe you can explain why fill down didn't work?

Just a guess--did you have the data filtered?

Dave S. wrote:

Dave,
Thanks for the recommendation, but when I tried it, I could not fill down.
I have 18 different e-mail address, but they cover over 800 locaitons. I
can't really type each address individually. Is their anyway to use the edit
fill down?

ds

"Dave Peterson" wrote:

Maybe you can dump the Insert|Hyperlink and replace them with the =hyperlink()
worksheet function (in an adjacent column).

If you have

in A1

Then you could use:
=hyperlink("mailto:"&a1,"Click me")
or
=hyperlink("mailto:"&a1,a1)
(and hide column A if you want)



Dave S. wrote:

I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

--

Dave Peterson


--

Dave Peterson