Copy entire row to corresponding sheets based on vlookup

[onbeillp111]

Hope someone can help with this. I have a workbook with 6 sheets, All Products, EVT, cDVT, DVT, RTM, and Data for drop downs. I have a code that works great and I am just trying to keep it better organized. Column B has a part number drop down list and when selected it populates columns C, D, and E with Vlookup. I want to modify the code I have so that when column E is EVT, cDVT, DVT, or RTM, it will copy the entire row and paste it into the corresponding sheet. I attempted to do this with only sheet "EVT" and I modified my code below in an attempt to get this to work. I bolded the only section that pertains to this question but below is my entire code.

Please Login or Register  to view this content.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[onbeillp111]

The vlookup formula I had in column 5 was the problem. Once i removed it the code worked fine.