I am not sure how to solve this spreadsheet quandry and want to ask for a little assistance. Here is the situation:
I have one worksheet (called 'data')with 20 names of people with each consecutive column being data about the person (DOB and other info). On another Worksheet (in the same workbook called 'name') I have a cell that you pick a persons name from a list. I then want the information populated from the 'data' worksheet to the 'name' sheet with the persons name I just selected. I am not sure the best way to do this. I have aboiut 7 fields that I want populated from the data worksheet to this name worksheet. What is the best way to accomplish this?
Thank you,
Guy