Hi All,
I've had experience with doing some VBA, but very basic stuff...and searching usually isn't a problem but this is more complicated then usual, when dealing with multiple sheets and combining data.
I can find one match and display it no problem...but finding all matches and displaying them is being picky.
I have 3 sheets with mostly unique data in each, they can be cross-referenced with 1 column in each sheet(reference#).
I want to create search page to search any of 3 or 4 columns, strings or date...then display the results below it.
all of the search criteria is in Sheet1, so not too bad...but I want to see all results relating to that search from each sheet, and its gets tricky because any of the records could have 1 result, or multiple results(records/rows).
I just want to display all results below the search, nothing too fancy, just he results from each sheet, since they all have different data.
I'm going to make the results more pretty into a userform later...but if you have advice, I'm all ears...
thanks in advance..for the help..(see attached for example)
Data_Search.xlsm
Bookmarks