Hi,
Here's my problem. Not everyone who uses my spreadsheet knows how to or cares how to properly sort a bunch of cells. I have a worksheet full of text and number data such as this (and you may say to use access, but that is not an option for me):

Company A address pieces description
Company B address2 pieces2 description2

etc.

So sometimes people highlight say both companies and addresses but not the pieces or description. Then we end up with Company A and address but with Company B's pieces and description and everything becomes unsorted.

Is there anyway to "lock" the rows so that no matter what you sort by it pulls the rest of the row's data along with it?

I would realllllly appreciate any help you can give me on this.

Thank you very much,
-Leela