Auto populate adjoining cells

[armstrob]

Hi all,

I am familiar with Excel as a basic user but I have now been tasked with doing a score system for a local club. I have put together a spreadsheet with two separate worksheets, one that the person hosting an event will enter scores and the other holding members details. What I want to accomplish is that when the hosting club takes an entry on the day, they can start to type in a surname or membership ID number in the relevant columns and Excel will look up from the members details worksheet. This will then populate the corresponding columns so that all that needs to be done by the event holder is enter the scores.

I have attached the spreadsheet to show what I mean and any help would be hugely appreciated,

Yours in hoping,

Bob.

[BeachRock]

Hi armstrob,

Take a look at the attached file. If this is what you were talking about, please mark the thread as solved.

I hope it helps.

[armstrob]

Beachrock, thank you so very much my friend. That is exactly what I was trying to do!!