Hi Dave,

Thanks a lot for the detailed reply. However, I have a couple of
questions:

1. The cell A2 is in the worksheet RAWdata - it is the data in RAWdata
that is being filtered to either IRdata or FLSdata, depending on
whether or not the column A entries in RAWdata is longer than 9
characters.

I guess I should change the line:

Set c = Range("A2")

to

Set c = Worksheets("RAWdata").Range("A2")

Right?

I also included

Sheets("RAWdata").Select

just before

a = Len(Cells(i, "A")) so that the macro measures
the length of the cell .
entry in Column A of
RAWdata.


2. There is a new error message this time:

For the line right after "Else",

ie, for: (Sheets("RAWdata").Select)

it says: "Subscript out of range". Why does this happen?

Thanks,

Joe.