Want data to be filtered by macro and with header

[Ratan Bhushan]

Hi team
I would like a macro which should filter on column"g"
if I select "cricket" then all the details highlighted in yellow should appear with all the respective headers.
Like if I select "helmet" then macro should produce the result with yellow line along with header
Copy this filtered data and paste to another file. And then save it.

I have uploaded the sample file also .

Please help.

Thanks
RatanB

 

[Chandrakant]

Dear Ratan,

Please find the attached file and click on button "DOIT" and see if this what you want.

I have made a list of values in cell H1 to be used to filter the data in G column first select the value in H1 and then click on "DOIT" button