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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting with linked worksheets
If you have formulas that look like:
=sheet1!a2 Then you're going to have trouble when you sort sheet1. Maybe you can put the names in the second sheet (as values--not formulas), then use =vlookup() to retrieve values from other columns based on matching that name. You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) sbrimley wrote: 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 -- Dave Peterson |
Reply |
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 |