How to group similar data?

[miss D]

Hi,
I have this report which has these fields in Excel.





How can I group the rows which has similar Mgr Email Addr? using Excel macro or VBA..
The grouping must be done this way..(it highlight the same group)



can someone help me?
thanks in advance

[Guido Geurs]

Dear,
I can't read the two frames in the call.
Please attach the files in Bytes in a ZIP file.

[miss D]

hi mr. guido,

i've edit the images and it can be viewed in the above question.

thank you in advance :)