i have a table that I copied from the internet, and i want to be able to sort the numerical data in the columns, but have it keyed to the names in the first column. right now when I sort the data in a column, it sorts, but the data is no longer associated with the name in the first column. how do i do this?



thanks

this can't be done?

Could you please post a small sheet showing some data and what went wrong?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

example...

name: age:
jim......56
john....24
jane....45


so the table looks like that, and when i try to sort the age column, the age column sorts, but the ages are no longer associated with the same names, so that it looks like this....

name: age:
jim .... 24
john ...45
jane .. 56

what can i do about this?

I'd guess there's empty column(s) between Name and Age columns.

Please post a sample sheet (Go advanced - Manage attachments). Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post