Extract data using arrays

[YasserKhalil]

Hello everyone
I have an attachment which consists of two sheets (Data sheet and Result sheet)
In Data sheet I hvae names in column B and Surrnames for speciifc names in column C ...
I need to extract the data related to specific name : the data required to be extracted :all the surnames related to that name and the Mark from Column G
There are the expected results for one name to get my issue
Thanks advanced

[nilem]

try it

Please Login or Register  to view this content.

[YasserKhalil]

Perfect Mr. Nilem
Thank you very much for this great help
I hope you post some comments on some lines to guide me learning such great code

[YasserKhalil]

Mr. Nilem
It's a perfect code but in fact it is so difficult for me to get it .. Can you comment on some lines so as to get it easily?
How can I get the column F also in Data sheet to be included in Result sheet (Yasser1 - 11 - 35 in three columns and so on)
Can I multiply the values 11 and 35 by specific cells in specific column .. for example : 11 * cells(I,4) "D4" .
How can I edit the code to achieve such modifications?

[nilem]

Hi YasserKhalil,

Could you presented an example of your data as they are in reality.

[YasserKhalil]

Ok Mr. Nilem Here's an illustration of the new point (Sorry for disturbing you)

[nilem]

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. Nilem for this magic code
You're awesome ...
It seems that it is very advanced code for me to get it .. Thank you very much