communication between sheets

Copper Contributor

Hello,

 

I made for my course soccerscout a simpel file with several informations about a game but most impotant is a player.

Now i have 3 sheets one is called setup one is called competition and the third is called international match.

When i fill in the sheet setup on the line 7 kind of game competition i want go to the sheet competition if the same line filled with international match. Wich formula i need to make this happen? Please answer me with dutch formula please.

0 Replies