Hey

Is it possible to sort an Excel database if you have drop-down lists? When I sort the data, the data validation cells stay and the data is not sorted with it's correct information.

eg
database of properties and owners.
Each owner has one name/ address / phone etc and a drop-down of all the properties they own. When I want to sort by first / surname or other info. The drop-down properties do not sort and are left to another owner.

Is there another way this can be done so there is only one owner, but with multiple addresses without resorting to listing the owner each time with each property??