Hi All. I need help to set up an auto copy or replication of rows onto another sheet. Basically i have a master sheet where i have rows relating to jobs/projects. On this row are cells with drop down lists. I would like to select an option on the drop down that would then replicate that whole row onto a new sheet. Each option on the drop down would have a respective sheet. If i were to then de-select the dropdown option then it would be automatically be removed from its respective sheet.