LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andybanker
 
Posts: n/a
Default Getting a hyperlink to follow a sort

Worksheet 1 is a table to list up to 100 prospective customers. Worksheets
2-101 are prospective customer profile forms. Each name cell on Worksheet 1
is hpyerlinked to a unique profile. The problem is when I re-sort the list
of names on worksheet 1, the hyperlinks remain with the cells and do not
"follow" the new location of the name caused by the sort. How can I get a
hyperlink (or some alternative) to stay with the row as it gets resorted?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort excel spreadsheet with hyperlink jannkatt Excel Discussion (Misc queries) 0 June 13th 06 01:39 PM
Formatting doesn't follow data sort kanimalhouse Excel Discussion (Misc queries) 1 September 7th 05 11:16 PM
when you sort named cells, the names do not follow the values Claude38 Excel Discussion (Misc queries) 1 August 16th 05 10:43 PM
How do I get a hyperlink (entire row) to data sort alphabetically Billie Excel Worksheet Functions 0 July 21st 05 04:30 PM
Excel Hyperlink: Is there an easier way to follow then double-cli. Bob Small Excel Discussion (Misc queries) 1 December 9th 04 11:24 PM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"