Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting with linked worksheets
I have 2 worksheets that are linked together. On worksheet A I have First
and Last name along with some other information. Worksheet B it is linked to have the First and Last name automatically put in for a seperate report. In worksheet B additional data is added such as test scores. When I sort Worksheet A to alphabetize the names worksheet B names are then alphabetized but the test scores do not change with the names. Is there a trick to sorting linked data so I can have the names in alpha order and the test scores will move with it. New names are added over a several month period so I am needing to sort each week. I am using Excel 2003 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) | |||
Sorting mixed up linked cells in a workbook? | Excel Worksheet Functions |