Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Importing XML data from http request | Excel Discussion (Misc queries) |