I have a user form with two combo boxes. The first combo box is populated from a named range of unique values found in the workbook in a data sheet (Column D). The macro to populate this unique list is working fine thanks to previous help on this forum.
The second combo box is to be populated by unique values from column E in my datasheet that matches the user's selection from combo box 1. I posted this problem before with no response, so I am hopeful that a more graphic depiction of what I want to do will be helpful to you experts.
Drawing2.jpg
Once the user is presented with and selects from the list of unique vehicle ID numbers in combo box2, I want all rows with that vehicle ID number to be copied to a new sheet (Sheet 5, Col A2).
Well above my VBA skills. Can anyone help?
Bookmarks