getting all data regarding a particular thing in a separate sheet

[paramnayak]

dear all,

say i have some data on a sheet eg

ajay maths 70
manoj history 80
ajay english 85

how can i get all data regarding ajay in a new sheet keeping in mind new data will keep on coming in the original sheet

 

[Somendra Misra]

Hi Paramnayak,

One quick question, are the two Ajay same boy or different boy. I means are there two Ajay in a class or There is just one Ajay in a class and you will update the score of same?

Regards,

 

[paramnayak]

they are same

 

[Somendra Misra]

Hi,

See the attached file.

Regards,

 

[paramnayak]

dear somendra,
this is exactly what i was looking for.
thanx a lot

 

[Somendra Misra]

Welcome Back anytime.

Regards,