Filtering information to extract top 5 matches but excluding certain criteria as well

[MeerkatMatt]

Hi all

I am brand new to VBA and have been thrown in at the deep end to produce a way of filtering mentors for mentees.

What will be happening is that a mentee will put in their details and what they are looking for by having a mentor using key words. The mentors will have provided similar information and I need to filter out the 5 best matches. They are not allowed to be in the same Org.Unit.

The spreadsheet that I am using (I have deleted some of the information as it is sensitive and not relevant to the filtering bit) is attached.

I'm not asking for someone to write the whole thing for me but if I could have a starter for 10 that would be really appreciated.

Thanks in advance.

Matt

[nathansav]

Please Login or Register  to view this content.

that will filter the sheet based on the criteria selected in the 1st row.

I'll look at the output in a bit.

[MeerkatMatt]

Thanks Nathan.

The next thing for me to do is understand how you got it to do what it does haha

[nathansav]

its not trick, the set bit, sets some objects up, so we can use a name for things rather than typing the full each time, the filter part is repeated, it filters field x (columns from the left) with the criteria of xxxxx