There are previous threads on this (copy row and a cut row) but I have been unable to get either code to work.
I have a workbook I call "Pipeline (date)" inside that workbook I have a spreadsheet called "Opportunities" and in column J of this spreadsheet I have created a drop down menu the selection I want to trigger a move is "6. Awarded"
I would love to make it so once I selected "6. Awarded" and ran the macro it would move that opportunity to another spreadsheet which I have titled "Awards"
I would like the move to be a cut and paste.
Any help would be appreciated.
I have a workbook I call "Pipeline (date)" inside that workbook I have a spreadsheet called "Opportunities" and in column J of this spreadsheet I have created a drop down menu the selection I want to trigger a move is "6. Awarded"
I would love to make it so once I selected "6. Awarded" and ran the macro it would move that opportunity to another spreadsheet which I have titled "Awards"
I would like the move to be a cut and paste.
Any help would be appreciated.