VBA code to automatically transfer data from one sheet to another based on dropdown

Hello,

I need a VBA code that will cut a row in one worksheet called "MKT" and transfer it to the worksheet called "Completed" based on me selecting "YES" from a dropdown menu. I have attached the file so you can get an idea.

Once the data is transferred from "MKT", I would like the row to be deleted.

Once on the "Completed" worksheet, I would also like to know which worksheet the information is coming from, because I will apply this formula to all the worksheets in the book, "MKT", "Business Model", "Product" and "People".

Thanks!

Well, I have three other tabs that I wanted to apply a similar code to that will populate the same "completed" tab.

Cutting the information off the primary tab will suffice. I just don't want it to continue there once the data is transferred.

Any suggestions?

Thanks

yes,

I want it to work on other worksheets as well.

There is no way to cut and paste with merged cells? If there isn't that is fine, the merged cells are purely asthetics.

Thanks

XeRo,

here is a copy of the file without the merged cells.

Think you can help me out?

Hey XeRo,

That's weird, I must have unmerged cells just on one tab. Sorry about that.

I just rearranged the rows and all that without merging anything and it worked beautifully, thanks a lot.

Is there any way for me to keep the formatting when it automatically switches the data to the "completed" tab?
If not, that's totally fine, what's important is that it's working, the formatting I can do manually, shouldn't take too much time.

Thanks a lot for your help!

Didn't work, what it doesn't keep the original formatting, but makes all the columns the same format, a random one; which is completely fine.

Don't worry about it man, you can put solved on this one.

thanks a lot!