View Single Post
  #1   Report Post  
Tiziano
 
Posts: n/a
Default Importing Data From Another Spreadsheet

I would like to import some data from another
spreadsheet. The spreadsheet that would supply
the data looks like this:

Column A Column B
-------- --------
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

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.