VBA Search and Copy

[JessLeigh]

I have two datetimepickers and two combo boxes in userform Find. I want to be able to search sheet1 by any or all the datetimepickers and combo boxes. If there is a match in either of the fields, then I would like the row (in sheet 1) the contains the match to be copied and put on the next available row in sheet2. I will need for all matches to be put on sheet2. I have the following code in place, but I am stuck as to where to go now. It will look for matches on sheet 1 from one of the combo boxes and will copy and paste that one cell match into sheet2.

Please Login or Register  to view this content.

Any help to fix the code to what I need it to be, will be much appreciated.

Thanks
Jessica

[Leith Ross]

Hello Jessica,

Welcome to the Forum!

It looks to me that you are searching only column "C" on "Sheet1". How will the user select which DateTime Picker and/or CombBox to include in the search or are looking for ideas?

[JessLeigh]

I was thinking I would create the same type of code for each combo box and datetimepicker. Like an and/else kind of thing. I haven't gotten that far yet, as I don't know how to get it to copy the whole row.