I'm attempting to build a routine that will compare values from a UserForm with multiple columns of a spreadsheet and return all rows that match all of those values which were not blank.
I'm not entirely certain how to go about it but I've started with a Search Subroutine and created a couple arrays
I've stored the values for any NON-Empty fields into both Fields() and Col()Please Login or Register to view this content.
My hope was to cycle through each row in my spreadsheet, comparing the values stored in the Fields() array with the corresponding Col()array to indicate which column in the row to compare.
Unfortunately some Fields are often unknown and as a result, have no value entered, so they are skipped as is the Col value.
I'm having difficulty, visualizing how to handle those inevitable gaps.
If only Fields(0), Fields(3) and Fields (5) have values stored and the same for Col(), how can I later, specifically call up those parts of the array for comparison to my spreadsheet.
Any assistance would be welcomed and appreciated.
Bookmarks