View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dylan @ UAFC[_2_] Dylan @ UAFC[_2_] is offline
external usenet poster
 
Posts: 76
Default 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?