Replicate or mirror row onto new sheet

Occasional Visitor

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.

Any help appricated!


1 Reply
You have to clearly explain what data you have and what results you want, without which you will never obtain a possible solution for the simple reason that there is no conceivable problem to solve.