Anuar malik
New Member
- Joined
- Apr 9, 2018
- Messages
- 1
Hi guys,
I'm very new in this excel VBA. I have a problem with this table. see the picture
This is sheet1 = all the data will be here.
this is sheet2: only the selected element will show. the problem is, i don't know how to link/get only the selected value data to show in sheet2.
I tried to use Vlookup/ index match but it's not working. u can download the excel file using this link.
https://drive.google.com/open?id=1iKSztpUjTW_qaRhJtlDt2aN3an3whxok Thanks.
I'm very new in this excel VBA. I have a problem with this table. see the picture
This is sheet1 = all the data will be here.

this is sheet2: only the selected element will show. the problem is, i don't know how to link/get only the selected value data to show in sheet2.

I tried to use Vlookup/ index match but it's not working. u can download the excel file using this link.
https://drive.google.com/open?id=1iKSztpUjTW_qaRhJtlDt2aN3an3whxok Thanks.