I have to transfer data from one sheet to another whenever the status of the case is closed. I have created the dropdown list with open and close in the first sheet and I want to have in the next sheet (which has the same data) only cases with status closed. Can you pls help me with this.
It is a very similar query to yours and the code supplied should work for you also. The criteria is in Column B. You may have to change this to suit yourself and you'll need to change the sheet references to suit yourself.
I assume that you would like to transfer complete rows of data once the criteria "Closed" has been placed in the appropriate cell in the appropriate column. I also assume that you have drop downs in each cell in the appropriate column.