Marko

Try Deborah Dalglieshes site Contextures.com. She has an
excellent page on autoFilters. There is also a macro by
Tom Ogilvy that copies filtered data into another sheet.

Regards
Peter Atherton
-----Original Message-----
Hi all,

I would like to search a column ("C") for a string and
when found copy/store
the row (or just the first 12 cells of it at least) and
keep searching till
all occurances are found, and then put the found rows
into another workbook.
I think I will need to put the found rows into an array
until the workbook
is searched. Is it possible to copy a row into an array
or will I have to
make a multidimensional array and copy the cells
individually?
I am currently acheiving this by an autofilter routine
but I need to do some
additional things once a string is found, like search
upwards to find the
first cell in bold (the header) and copy it to the end of
the stored row(or
maybe a variable).
Can anyone help?

Thanks
Marko


.