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.

I entered your thread title in Google and got 108 Mo answers.
Have you already searched the Net?
This is a quite common problem

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post