Hi,

I have a worksheet called "Potential Opportunities" with column C being a dropdown list to select a status. I have two other worksheets "Added to Pipeline" and "Disqualified". I would like to create a macro so that if the "Added to Pipeline" status is selected in the "Potential Opportunities" worksheet, the row is automatically moved to the "Added to Pipeline" sheet and if the "No--Disqualified" status is selected, the row is moved to the "Disqualified" sheet. After a row is moved, I would like for it to be removed from the "Potential Opportunities" worksheet.

Any help with accomplishing this would be much appreciated. I've found several code examples but can't figure out how to get it to work in my workbook. If you need any other info or for me to upload my workbook, just let me know.

Thanks!