I would like to be able to take data from one sheet and have it moved to a new sheet if certain criteria is met. Is this possible?



I have a spreadsheet with a list of equipment that sometimes gets signed out to other individuals. I have a cell that contains a drop down list of personnel an I know that I can sort by using that field. I would like to have the data move to a new sheet within the same workbook.