Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping rows together during column sorts of linked worksheets
I have a source worksheet from which I've linked several other worksheets. If
I alpha sort the source worksheet, the sort results are fine -- has column-for-column, row-for-row integrity -- all information in rows stays together with the individual's NAME, which is what is sorted. However, if I sort any worksheet that's linked to my primary worksheet, and I alpha sort the NAMES column, the information from cells in other columns of that row do not sort with it. DESPERATE -- Help!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping rows together during column sorts of linked worksheets
Rather than direct linking your data to the source list, use the "vlookup"
function. For example, if your source is on "sheet1" in cells "A1" through "B4": Name Age Frank 1 Kim 4 Joe 3 Assuming your next set of data is on "sheet2", add the vlookup formula to column B: Name Age Frank =VLOOKUP(A2,Sheet1!$A$2:$B$4,2,FALSE) Kim =VLOOKUP(A3,Sheet1!$A$2:$B$4,2,FALSE) Joe =VLOOKUP(A4,Sheet1!$A$2:$B$4,2,FALSE) -- John "judie" wrote: I have a source worksheet from which I've linked several other worksheets. If I alpha sort the source worksheet, the sort results are fine -- has column-for-column, row-for-row integrity -- all information in rows stays together with the individual's NAME, which is what is sorted. However, if I sort any worksheet that's linked to my primary worksheet, and I alpha sort the NAMES column, the information from cells in other columns of that row do not sort with it. DESPERATE -- Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping the same format in linked worksheets | Excel Worksheet Functions | |||
Keeping formulas on running total and sorts | Excel Worksheet Functions | |||
inserting rows in linked worksheets | Excel Discussion (Misc queries) | |||
Question about deleting rows from sorted linked worksheets | Excel Worksheet Functions | |||
How do I save & apply sorts subtotals in excel to new worksheets? | Excel Discussion (Misc queries) |