Data Sort & Maintain Link Positions

V

virtualfunker

I have a spreadsheet with list of data that have hyperlinks. I then have
option buttons to sort for two conditions I wish to switch to but the link
stay with the cell and does not move with the sort.

Can I have the link moving with the sort?

Thanks.
 
D

Dave Peterson

I put a few rows of data in a new worksheet.
I added hyperlinks via Insert|hyperlink.

Then I sorted by the values in the cell.
The hyperlinks stayed with the values.

I used xl2002.

How did you insert your hyperlink?
 

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

Hyperlinks and Sorting Problems 4
if i sort cell that has link to another page how to keep link 1
How do I sort e-mail addresses without losing the links? 4
Combo Box and Sorting 3
writing a sort macro 2
sort multiple columns 5
Background stays when sorting 2
Link Data from several colums into a single one and sort 1

Top