filter features+macro

hello
im after something which im not in all honesty quite sure how to go about

i have data in a very large workbook that basically looks like a huge fixture list

column a = home score
column b = home team
column c = "v"
column d = away team
column e = away score

i want to be able to search via a userfom in two different ways

1 section would have input team
so it would then look for that team name in column b and column d and return all the results in sheet 2
eg lets use man utd
it then searches all b and d and returns all results into sheet 2

section 2 would be
team v team
it would need to be able to search for the first input teamin columns b and d
and
search for the second input team via columns b and d then return the details on sheet 3

i need it to do this for me rather than filter and copy and paste as that takes too much time

many thanks for any help you may give

It would help us help you if you could post a small example of your data.

when worbook opens i would like a userform to pop up

top section
input team name

bottom section
input team name v input team name

if top section i entered arsenal
it would return
1 arsenal v barnsley 3 AND
1 norwich city v arsenal 3 ( because arsenal is in column b and d for both of these records )

yet if i used the bottom section and input arsenal v norwich
it would return
1 norwich city v arsenal 3 (because this is the only time they have met and arsenal even though arsena are away)

hope thats explanatory

Try this.
You will need to update the clubs list for full data set.

Basically the routine compares team name against content of column b or d for each row.
If the names match then the row of data is copied to the appropriate sheet.

Was there something specific you need help understanding?

okay but what's the question?

The code should work but you will need to adjust the range references.

team names are in columns b and d or 2 and 4.
where as player names are in d and g or 4 and 7.

you would also need to change the sheet of club names for a sheet of player names.

So taking the routine and making this small change means you can use it for both football or darts by just changing 2 variables

Please Login or Register  to view this content.

I posted my code before I saw your darts data file.
The code is valid still but you also need to make a change to the calling code in order to pick up the extra information.
So you need to increase the Resize value to cover more columns

Please Login or Register  to view this content.

That's because you have changed the functions signature.

You need to change the call to that function. These are within the Click event of the 2 buttons.

see attached.

I copied dart data in to the workbook and adjusted code accordingly