Dear All,

I have created an excel sheet that export attached file , each time it it exported by different tables , the attached one is for Some one called Heba Riad and for week 1 as shown in below tabs.

in the second sheet there is selected info related to this person is highlighted as shown in the picture below
Book55.xlsx
H.png
if there any way create a Macro ( in a button ) to search always for relevant information of this person and show it only , knowing that the person name could be extracted from the first tab name or even jsut create it to this person now " Heba Riad " and i will adjust it later per person name , but the main riddile to select highlthed information only


Ps: I posted this in more than on fourm seeking answers , with all do recoginzation to whoever could help me in
Post 1 : http://www.mrexcel.com/forum/excel-q...arch-show.html
post 2 : http://www.ozgrid.com/forum/showthread.php?t=189316