Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to maintain hyperlink when sorting data?
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. |
#2
|
|||
|
|||
It sounds like your hyperlinks are created using formulas?
******************* ~Anne Troy www.OfficeArticles.com "KJ" wrote in message ... 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. |
#3
|
|||
|
|||
How to maintain hyperlink when sorting data?
I'm having the exact same problem--did you find a way around it??
Erik "KJ" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks and sorting data | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Need help Sorting data | Excel Worksheet Functions | |||
How do I get a hyperlink to track data movement? | Excel Discussion (Misc queries) | |||
Help in Sorting Data Please! | Excel Worksheet Functions |