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 |
All times are GMT +1. The time now is 11:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com