Can anyone possibly suggest a solution to this small problem.
I'm sure it's very easy, but I just can't think of how to do it.

I have a worksheet with the following columns

A B C
Quantity Type Distance(mm)
3 X 1243
1 X 2256
2 Y 876
1 X 6556
3 Y 554
1 X 222


I would like to create a table on a separate worksheet with the same column
headings, but only have a list of the type 'X' (i.e. ignore everything apart
from X)
Like this, without any blank rows between:
A B C
Quantity Type Distance(mm)
3 X 1243
1 X 2256
1 X 6656
1 X 222

However, there are one or two restrictions...
Also, I cannot modify the original table (I cannot sort the data)
Occasionally, the columns are in a different order when I recieve the data
(therefore I name the columns are 'ranges' [in case it helps])

Hopefully I have explained my problem clearly.

Thank you in advance.