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