Loosing correct hyperlnk location after sorting spreadsheet data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tabs (Sheet1 and Sheet2) within a spreadsheet and have created a
hyperlink within Sheet1 to Sheet2!D3. When I sort the data within Sheet2 the
hyperlink in sheet1 is still pointing to Sheet2!D3 even though the sort moved
the data to cell D5. The same problem occurs when I manually change the row
location within Sheet2. Why isn't the hyperlink retaining the new location
after the sort or manual cut/paste of a row?
 
It doesn't work with sort. However, if you NAME the cell you are
pointing to and in your hyperlink choose "defined names" and the name
you specified, it will at least take care of manual movements.

Hans
 
Naming the cell and using the defined name as the hyperlink does handle the
ability to change row location using a cut & paste. I was hoping identify a
solution where I could use a sort function.

Thanks much for your reply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help! I am having a problem with sort! 2
Row names will not move with sort 1
Prevent cell/array references from changing when altering/moving thecell/array 1
Why does "cut and paste" cause #REF! errors? 4
How do I get a hyperlink to track specific data in a worksheet? 1
Code to Copy Data from One Spreadsheet To Another 9
Update defined name ranges after sort 3
Hyperlink to a location on worksheet and display full image. 1

Back
Top