Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

Reply
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
Data Integrity Error Message simmerdown Excel Discussion (Misc queries) 0 May 16th 08 03:45 PM
Validating or checking data integrity function ali Excel Discussion (Misc queries) 2 September 12th 07 09:32 AM
Links not updated when primary worksheet is sorted Susi Farmer Excel Worksheet Functions 4 June 25th 07 09:26 PM
data formatting integrity [email protected] Excel Discussion (Misc queries) 1 April 11th 07 07:02 PM
Preserving data integrity in linked workbooks KG Excel Discussion (Misc queries) 1 February 18th 05 12:45 AM


All times are GMT +1. The time now is 06:13 PM.

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

About Us

"It's about Microsoft Excel"