On 8/19/2010 8:59 AM, JT wrote:
Thanks Don

I would usually use an array or sumproduct formula approach to
generate my filtered list but the sheer volume of data in this case
makes it too slow.
<snip

How many rows of data do you have? I was going to suggest you copy the
Worksheets(N).UsedRange into a string, split the string into an array
using the vbCrLf character (so each row is in its own array element),
then loop through the array writing any lines that don't contain the
string you mentioned to the filtered data sheet.

alldata() = Split(usedrangedata, vbCrLf)

Will that approach work for you?

Mike