I'm trying to create a spreadsheet to send to students so they can choose the
dates they'd prefer to attend classes. I've used data validation to format
cells in three columns--basically, the drop-down menu offers between two and
five date choices, and the three columns are labeled as 1st choice, 2nd
choice, 3rd choice. The fourth column is a list of class names. When I try
to sort alphabetically by class name, the data-validated cells do not sort
with the class names column. They stay where they were. I want the data
validation cells to move with the class name cells. For instance, if, before
sorting, Economics was in cell A21 and the data validation cells showing
available dates for Economics were in cells B21, C21, and D21, then after
sorting, I would expect that if A21 became A1, then B21, C21, and D21 would
now be B1, C1, and D1, but this is not the case--they stay as B21, C21, and
D21. Any help would be appreciated!