View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Sorting cells: a list behind the cells do not move with the cell

Yep.

Maybe you can reassign the data|validation after the sort????

Ross M wrote:

Using the option Data Validation Settings, I created a list of names
behind the cell for use as a drop-down list.
I did the same with other cells underneath each cell creating different cell
lists.
When I later decide to sort the column, the sorting works on the surface but
the drop-down lists behind the cells do not move with the Sort, hence I then
end up with drop-down lists that are not relevant to the cell


--

Dave Peterson