Find Character in text then copy row

Hi, I appreciate all help here which is invaluable to me as I keep the message for further macros
in Sheet1 Column 10 Find character where text is like this "X**" then copy whole row A:F to first empty cell in sheet2.
As you can see there are cells which are empty as well

examples:
9632x
20x70 This is True
84x7x
3986x
9959x

0

80x
80x
2896x
x752x This is False
97x0
2x588
48x30 this is true
09x42 this is true
359x6
97x69 this is true

Any help will be appreciated
Regards
Graham

Grahamfeeley,

Here's how I read your problem.

Please Login or Register  to view this content.

Thanks for your help, however it stops on this line
.AdvancedFilter 1, .Parent.[z1:z2]
Regards
Graham

This code does copy but not what is required
Thanks for trying
Graham

Working, otherwise you need to upload your workbook.

Ok sorry about that, I hope you all realize I really appreciate all your help
I will upload my file

Please Login or Register  to view this content.

Leelnich actually your code did the trick, works perfectly and fast as well

Thanks guys for all your participation
Graham

Jindin , thanks for the code last post code works perfectly
Much appreciated
Graham