If cell = yes then copy row to another sheet

[robertsonglenn80]

Hi,

I have two sheets in my spreadsheet. The first is called 'data' and the second is called 'Yes'.
The sheet 'data' has a number of header coloumns where the user will input date. In column D of the data sheet it is titled 'Phone' and the cells in the column are validated so user can either select yes or no.
I need it so that if 'Yes' is selected excel copies that row of information and puts it in the next free row on sheet 'Yes'. If no is selected then it can just stay in data.

Thanks

[arlu1201]

Try this code

Please Login or Register  to view this content.

Right click on the sheet and select View Code. Copy this code over.