Thread
:
How to sort data with off-sheet dependents?
View Single Post
#
2
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
How to sort data with off-sheet dependents?
i created a little workbook made up a list and copied it,I then pasted a link
to that range(paste special paste links) and when i sort the source list the
dependent one follows it.
--
paul
remove nospam for email addy!
" wrote:
I have a workbook with two worksheets, one called "Summary", the other
with the raw data. The "Summary" worksheet refers to cells in the "raw
data" worksheet. To my surprise, when I sorted blocks of data in the
"raw data" worksheet, the relative references in the "Summary"
worksheet were not updated.
First, is that an Excel defect, or did I do something wrong, or are my
expectations misplaced?
If it is a known defect, has it been fixed? I am using Office Excel
2003 (11.8033.8036) SP2.
Second, is there a simple way that I can set up the references in the
"Summary" worksheet so that they track movement of the cells in the
"raw data" worksheet -- especially, sorting?
(They do track simple movements, e.g. when rows and columns are
inserted, and even when cells are moved individually.)
Reply With Quote
paul
View Public Profile
Find all posts by paul