the data is like this:

Col A Col B

10
20
30 X
40
50
60 X

i would like a macro to copy only 30 and 60 because there is an "X" against them in column B.

i would like the macro to copy this values on the clipboard or a list with no blanks..

can anyone help? thanx