Very much an amateur excel user. If you respond don't assume I know very much about excel. Here is my problem:
I have 26 columns on worksheet 1. Each column has a name in the top cell a telephone number in the second cell and then a cell with with a number (this number comes from worksheet 2). What I would like to do is to sort worksheet 1 automatically by the lowest number (associated name, tel. number would have to be displayed as well). Lowest numbered column on the left and each column to the right is the next highest in number.
example:
name A name B
555 1212 555 2121

3 2

Sort the 3 and 2 with the names/tel#. If you can help me it certainly will be appreciated.