I am new to VBA code, I am trying to create a search with 10 criteria in a userform, 2 of which are a start date and end date and the other 8 are categories and sub categories and descriptions. I want the option to leave some or all of the search criteria blank and return the full row of any records that match my search in a different worksheet called "SearchResults" from my database called "Projects". I can get the search criteria to populate the correct cells from the userform but cant get the advanced filters to update automatically. I am open to doing this with all VBA code or with Excel functionality but need it to work in a very user friendly way, so I am doing as much as possible with userforms and macros. This will be used by a bunch of people other than myself so I am trying to make it as foolproof as possible so i dont have to keep explaining how it works or how to input or search new data. Any help you could give would be very much appreciated.
JasonB
JasonB
