Search and show

[engmhelmy]

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
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

Book55.xlsx

[Pepe Le Mokko]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.
http://www.excelforum.com/excel-form...-and-show.html