Filtering and Data Validation
 

I have a spreadsheet with some columns containing drop down lists made with
data validation. I filtered the spreadsheet once and the data validation
columns remained, but when I filtered it again, using a second criteria, I
lost the data validation. The lists I made out to the side of my spreadsheet
for the drop down boxes disappeared. Why does this happen? I need to be
able to filter this info using 2 different criteria, keeping the data
validation and then copy the results into a separata separate spreadsheet.

Thanks, Susan