Posts by bradrhall

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

Thanks, appreciate all the help.

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.

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

Thank you so much. This is exactly what i needed.

I have removed the merged cells.

How do i move the database to a separate sheet, but keep the formulas?

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.