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.
Bookmarks