ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Keep integrity of pasted links when data is later sorted (https://www.excelbanter.com/excel-worksheet-functions/213797-keep-integrity-pasted-links-when-data-later-sorted.html)

John in Venice

Keep integrity of pasted links when data is later sorted
 
I've pasted a link from data in a worksheet into another worksheet. The data
is part of a large list. When I later sort that list, the pasted link seems
to be lost. Is there a way to keep the integrity of a pasted link after the
original data is sorted?

Dylan @ UAFC[_2_]

Keep integrity of pasted links when data is later sorted
 
does this data hyperlink to something
when you link what are you refering to

or are you asking if you
copy and past a list of row that contain what ever
randam serries of data and then say sort by a to z
do out want to replace the list order to its
original order
esay way is just ctrl z and sever uasable sorts
you should be able to understand the data
to were the random order of the original should
have no signifignce

"John in Venice" wrote:

I've pasted a link from data in a worksheet into another worksheet. The data
is part of a large list. When I later sort that list, the pasted link seems
to be lost. Is there a way to keep the integrity of a pasted link after the
original data is sorted?



All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com