H
Harried in Hicksville
Here's what I have. I have a document used to record and track dog licenses
in my city. There are 11 columns in the document. One column contains
numbers as currency (not set up as text). I want to sort the document in two
ways. I want to be able to sort so they are listed by license number (column
1), but I also want to be able to sort so they are listed by owner's name
(column 2). Two different lists. My problem is that I can't seem to get the
sort to carry across the 11 columns. When I try to sort a row by license
number, for example, the sort only takes some of the columns with it, so I
end up with wrong information in the row.
Hope this makes sense!
in my city. There are 11 columns in the document. One column contains
numbers as currency (not set up as text). I want to sort the document in two
ways. I want to be able to sort so they are listed by license number (column
1), but I also want to be able to sort so they are listed by owner's name
(column 2). Two different lists. My problem is that I can't seem to get the
sort to carry across the 11 columns. When I try to sort a row by license
number, for example, the sort only takes some of the columns with it, so I
end up with wrong information in the row.
Hope this makes sense!