Copying data between worksheets dependent on drop menu selection

[Steve_f]

Hi All, I am attempting to create a spreadsheet and would like to know if it is possible if somebody selects "yes" from a drop menu options of "yes/no" that the row is automatically copied from one worksheet to another that is password protected?
I want the first sheet to accumulate the workflow coming into my team but only copy the items that are ready to the second worksheet that will be password protected for their use only.
Any help will be greatly appreciated please?
Steve

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...p-menu-selection-post5321726.html#post5321726

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.