SubData : Pulling Up Records based on reference field across worksheet

[KumarS]

Hi Experts,

Need help in achieving the following scenario.

In one of the worksheet , I have multiple rows as mentioned below :

John 1 2
John 3 4
John 5 6
Mark 7 8
Mark 9 9

And in the 2nd worksheet of the same excel , I have the reference field for the Name as below :

John
Mark

Now I need to pull all the 3 records present in 1st worksheet in to the 2nd worksheet based on the name John, similarly for Mark
we need to pull 2 records from 1st worksheet in to the 2nd worksheet.

Please advice .

Thanks,
Kumar

 

[sijpie]

so what would your 2nd sheet look like when it is done correctly?