Cut and paste row from worksheet to another worksheet based on drop down selection

Hello,

I am new to this forum and this is my first post. I am looking forward to some expert help solving couple of roadblocks I am facing currently.

How to cut rows from "Daily Activity" worksheet based on the drop down values selected in the "Completed,Postponed,Turn Down" coloumn and paste them to "Completed Cancelled PostponeJOB" worksheet under the Completed, Postphoned and turned down tables. This needs to be automated so we can at the end of the month determine what were the no. of jobs we turned down and attach a dollar value to that.

Another part is to have a window pop up when the Crew is selected "Crew1" then it should display a window with the names of the crew members similarlly for crew 2...11

Thanks for reading and helping out!

Search this forum, there are loads like this each week

There's loads on Google about the complexities of copying merged cells.