search by one id number

[Waqas ali]

hi,
i want to get data base on id number. if i enter id number in cell all data related to this id number should appear.

i tried vlookup but it shows only one record. i want all data even more than one record related to one id number.

if in macro than how?

 

[anglais428]

I think a pivot table would work best in this case.

 

[Waqas ali]

thanks,
i know but i want to do with vba code.
it should look like parent and child record
parent is one but child can more than one.

 

[Waqas ali]

hi Experts.
i require your experties to solve my question.

thanks