Hi people
Been a while, Sheet Summary contains a Search button activates a userform in which i have a combobox and a listbox, combobox has a list of names by choosing one it populates the listbox with a list of products, what I want is to click the product in the listbox this will then search a sheet named Log, column "D" contains the names (combobox) and column "G" contains the name of product so when the search matches name and product chosen by combobox and listbox it should copy the entire row to the Summary sheet, there will be multiple instances of the match so the Summary sheet should contain all rows matching combobox and listbox selection, I did try some vba but I could only get it to do one criteria not two, hope I have explained it ok
Thanks in advance
John
Bookmarks