One way..

Suppose this data is in Sheet1, cols A and B, row1 down

A6520 04-02 X
1511 03-01-VT X
S6520 00
mtr-AAA-TR565
BC6520 04-02-01 X
D6520 00-ABC
8951511 03-01-VTM X

Use an empty col, col C?
Put in C1: =IF(B1="x",ROW(),"")
Copy down by as many rows as there is data in cols A and B

In Sheet2
-----------
Put in say, A1:

=IF(ISERROR(MATCH(SMALL(Sheet1!$C:$C,ROWS($A$1:A1) ),Sheet1!$C:$C,0)),"",INDE
X(Sheet1!A:A,MATCH(SMALL(Sheet1!$C:$C,ROWS($A$1:A1 )),Sheet1!$C:$C,0)))

Copy down by as many rows as was done in col C in Sheet1

You'll get:

A6520 04-02
1511 03-01-VT
BC6520 04-02-01
8951511 03-01-VTM
(rest are blanks)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Tiziano" wrote in message
...
I would like to import some data from another
spreadsheet. The spreadsheet that would supply
the data looks like this:

Column A Column B
-------- --------

The X's in col. B are the result of an IF
formula, something like =if(c32000,"X",""),
etc., thus they will/will not be there depending
on the values in col. C.

The data in col. A should be imported into
the other spreadsheet only if an X is present
in col. B. Also, it should be imported in
such a manner as not to leave blank rows inbetween
each piece of data imported.

Therefore, the data imported into the other
spreadsheet should look like this:
A6520 04-02
1511 03-01-VT
BC6520 04-02-01
8951511 03-01-VTM

I would appreciate any suggestions as to how
to set up the formula to import the data.
Thanks.