Search the cell value and Select the entire row.

Hello,

I need help again !

What i am trying here, is I am search a cell value which is actually a header for my data. So When I search the Data (Ctrl+F) it go to that cell, then I want the entire row of that Cell to be selected, So I can do the copy of that into another sheet?

Can we do that with macro?


Regards