Hi I need help here.
I have a workbook with 2 worksheets; worksheet 1 was given a name as "Names" and worksheet 2 was given a name as "Data".
In worksheet 1, I have a list of data which consist of column A - Name, column B - Email address, column C - contact no, column D - Residential address. I have a total of 10 rows with these data. Each row in column A has a different name. Eg: Row A1 is Andy, Row A2 is Lisa, Row A3 is Tommy and so on until row 10. I wan to, when I click on row A1, Andy's name, it will appeared all the details sheet 2. And if I click on Lisa, Lisa's details will be shown in sheet 2. However I do not know how to put into macro formula. However, I have insert index match for all the columns except column A as I wan to click their name and it appeared in sheet 2 with the details. Pls kindly assist me. Thanks alot!