Macros formula

[Gredang]

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!

 

[vletm]

Gredang​

Here's one sample.

 

[Gredang]

Hi thanks for the sample but it cant work.

 

[Gredang]

Name	Email Address	Contact No	Residential Address	Status
Andy	Andy@Gmail.com	018235671123	Mt Elise Road	Single
Lisa	lisa@gmail.com	019783356212	Changri Road	Single
Tommy	tommy@gmail.com	021673321981	Sponner Road	Single

Basically the 1st sheet looks like this.

the 2nd sheet will look something like this:

Name
Email Address
Contact No
Residential Address
Status

So basically i wan to click on the 1st sheet, the name "Andy", Andy will automatically appear in 2nd sheet with all the details.

Able to assist?

Thank you.

 

[vletm]

Gredang​

Why it can't work?
Your original thread is
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 wan to, when I click on row A1, Andy’s name, it will appeared all the details sheet 2.
My sample did not have those names or other datas.
Now, Your Basically the 1st sheet looks something else.

Have You read?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[Gredang]

Hi. That’s what I’m trying to explain. I do not have the file with me as my office computer does not allow me to send out files. Maybe my 1st explanation isn’t clear, my apologies.

 

[vletm]

Gredang​

Header row, different number of columns and
do You really would like to get the 2nd sheet something like that?
... if so, then the 2nd sheet is always fixed ... with those headers.

 

[vletm]

Continue

VBA formula not working

Hi! 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 - number, column C - Tpass, column D - pic,etc. I have a total of 60 rows with these...

chandoo.org