Exporting filtered set

[Joseph N.]

I would like to convert a workbook from Lotus 1-2-3 to Excel, but I
cannot find a way to reproduce the functionality that is key to making
this particular file useful. The file is two sheets, one of which
contains a multi-column list. One of the columns indicates whether the
data for that record have been exported to an external database. In
1-2-3, a query can be run on the table to find the records that do not
have "Y" in that column's cell, i.e., which have not yet been exported,
and the query result populates a table on the second sheet in the
workbook. Then, that table (on sheet two) is exported from 1-2-3 and
imported into the external database.

The problem I'm having is getting Excel to find the non-exported
records (without "Y" in the first column) in a way that produces
something--anything--that can be imported into the separate database.
Filtering appears to do it, but the data that is exported, or even
copied to the clipboard, also contains the filtered out records.

Surely there is a way to do this.... Can someone help, please? [Excel
2003]

 

[Dave Peterson]

When I copy a filtered (data|Filter|autofilter) list, I get only the visible
rows in my clipboard--I even pasted to notepad to double check.

xl95 was the last version that would copy all the rows.

But if you're not using data|filter|autofilter, maybe you could add another
step.

Select the range (with the hidden & visible rows)
edit|goto|special
visible cells only

Then copy|paste

I would like to convert a workbook from Lotus 1-2-3 to Excel, but I
cannot find a way to reproduce the functionality that is key to making
this particular file useful. The file is two sheets, one of which
contains a multi-column list. One of the columns indicates whether the
data for that record have been exported to an external database. In
1-2-3, a query can be run on the table to find the records that do not
have "Y" in that column's cell, i.e., which have not yet been exported,
and the query result populates a table on the second sheet in the
workbook. Then, that table (on sheet two) is exported from 1-2-3 and
imported into the external database.

The problem I'm having is getting Excel to find the non-exported
records (without "Y" in the first column) in a way that produces
something--anything--that can be imported into the separate database.
Filtering appears to do it, but the data that is exported, or even
copied to the clipboard, also contains the filtered out records.

Surely there is a way to do this.... Can someone help, please? [Excel
2003]