Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns
My spreadsheet/table roughly has the following appearance:
A B C D Abel 123 Victor 345 Bob 454 Wayne 563 Mark 543 William 234 Tom 999 Zane 145 There are 2 columns each of names associated with ID numbers. Columns A and C are currently sorted alphabetically. I would like to have the above information linked in a separate sheet, but sorted by ID number. The result should look like this: A B C D Abel 123 Bob 454 Zane 145 Mark 543 William 234 Wayne 563 Victor 345 Tom 999 So, my question: Is there a quick way to copy the first table above into a separate sheet so that it looks like my second table which is sorted by ID number? I'd also like to have the second table linked to the first table, so if I change any name in table 1, it should be reflected in table 2. thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary | Excel Programming | |||
freezing columns labels while sorting columns | New Users to Excel | |||
Sorting Columns | Excel Discussion (Misc queries) | |||
Need help with sorting of three columns | Excel Programming | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) |