Posts by bradrhall

    Re: Auto populate cells to the right of a dropdown box

    I'm using 2010. I appreciate the help, but I'm now confused as to what has been done.

    The first example was perfect, but it would help if the player database sat in sheet 2.

    Been able to add extra players, without messing up the formulas would be great.

    I'm not sure what happened to the date of birth and age, it's not calculating correctly on the 2nd example sheet.

    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.