Using Drop Down in one sheet to push row to next sheet based on Selection

I am trying to use a drop down list in one sheet to then add the row of data to a second sheet based on the selection made. More specifically when an item is deemed "closed on sheet one I want them to copy to a list of closed issues on a sheet called Closed Issues.


Thanks in advance for any help/hints.

Hello, interesting problem. If you like this solution (button launches a macro for you, pasted below). please increase my reputation (click on the scales icon at the upper right hand corner of this post).

Open the attachment, you will find a button to do this on the top of the "Open Issues" worksheet.

Please Login or Register  to view this content.