Extract Certain Data from closed file

[joecrabtree]

To All,

I want to be able to do the following:

Spreadsheet data.xls is a CLOSED spreadsheet that contains many columns
and rows of data. I want to search column C of this spreadsheet, and
extract all the rows that contain FR55 in column C to a spreadsheet
newdata.xls. The macro needs to be contained in spreadsheet newdata.xls
and extract the data from data.xls.

Any ideas?

thanks in advance,

Regards

Joseph Crabtree

 

[Franz Verga]

Nel post *joecrabtree* ha scritto:

To All,

I want to be able to do the following:

Spreadsheet data.xls is a CLOSED spreadsheet that contains many
columns and rows of data. I want to search column C of this
spreadsheet, and extract all the rows that contain FR55 in column C
to a spreadsheet newdata.xls. The macro needs to be contained in
spreadsheet newdata.xls and extract the data from data.xls.

Any ideas?

thanks in advance,

Regards

Joseph Crabtree

Hi Joseph,

Try to see here:

http://www.erlandsendata.no/english/index.php?d=envbadacimportwbado

http://www.erlandsendata.no/english/index.php?d=envbadacwbdbado

http://www.erlandsendata.no/english/index.php?d=envbadacwbdbdao

I think you should find something to solve your problem...

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Dave Peterson]

I'd open data.xls and use data|Filter|autofilter on the worksheet in column C.
Then filter to show FR55's and copy the visible range to the other location.
Then close data.xls.

With screenupdating turned off, it should be invisible to the user.