Hi I'm really struggling to fine a solution to this problem.
I have a team sheet for rugby that requires completing weekly.
I have created a player database to the right of the team sheet.
I have used Data Validation to create a drop down list for the players surname.
What i'm trying to achieve, is if I select a player surname, the rest of the data in the players database populates across to the team sheet.
I hope this all makes sense, and someone can advise me on this.
Thanks in advance.