Data (Drop Down) Value in 1 Worksheet / Copied-Updated to Another Worksheet

I have (in A3) a drop down data list (that I created); if it contains a specific value (3 choices), I want to copy the whole row to another worksheet and give a summary. The 1st worksheet is like the "Master List" and then I need summary sheets, based on the specific Value in cell A3, B3, C3, etc.

Thank you! Susan

Originally Posted by SMurtagh

I have (in A3) a drop down data list (that I created); if it contains a specific value (3 choices), I want to copy the whole row to another worksheet and give a summary. The 1st worksheet is like the "Master List" and then I need summary sheets, based on the specific Value in cell A3, B3, C3, etc.

Thank you! Susan

if you send us a draft file, everything will be easier