Automatically place people in a crrespondeng sheet from an overview

Hi Guys,

Still working on the fisching club Excel sheet.

I have an overview of all people that have entered fishing matches.
For each match I also made a separate sheet for the results.

What I would like is to fill in the separate sheets automatically when I enter e new entry in the overview.
In the excel sheet supplied 4 sheets: Scheme, Overview, match 1 and match 2
Only names need to be copied to the corresponding sheets based on which match.

How can I do this?
Thanks for the help.

Put this array formula in B2 on the "Match 1" sheet and confirm with Ctrl+Shift+Enter rather than just Enter and copy down.

Formula:

Please Login or Register  to view this content.

You can use the same for other sheets, you just need to change "Match 1" to "Match 2" etc.

BSB

I can't get to work in the final document.
Copy pasted it changed the names to the right sheets. Made sure I used Ctr + Shift + Enter to make it an array formula.

I've tried on sheet Voorj 1 but it's not showing what I expected it to show.

The formula doesn't work because it's including rows without names in. If you changed instances of 501 in your formula to 6 you'll see it works fine.

In the attached version I've set up two dynamic named ranges so they expand/contract as you add/remove names.
I've altered the formula to take account of these and all works as expected.

Formula:

Please Login or Register  to view this content.

BSB

You are matching "Voorja 1" vs "Voorjaarswedstrijd 1" so no match


=IFERROR(INDEX(Inschrijvingen!B$2:B$501,SMALL(IF(Inschrijvingen!D$2:D$501="Voorjaarswedstrijd 1",ROW(Inschrijvingen!$2:$501)-1,""),ROWS($1:1))),"")


and remove ~N/A in "Inschrijvingen"

column D and E

=IFERROR(VLOOKUP(C2,Schema!A:J,3,0),"")


=IFERROR(VLOOKUP(C2,Schema!A:J,10,0),"")

I tried that and it didn't work for me. Hence the named ranges.
Just tried it again and it worked! I must have had a typo first time round.

Anyway, now there are two solutions

BSB

Now it's working fine Thanks a lot for the help.
Now it's copy pasting it to all the other matches.
Saves me a lot of copy pasting when I make new entries.

Again thanks very much!