sounds like homework
Use a combination of IF and FIND and COPY

--
Don Guillett
SalesAid Software

"Greg B" wrote in message
...
I have a workbook with 140+ worksheets in it and I want to have a macro to
look up if the worksheet has the letter "m" in cell "i1". If the
worksheet
has this then I would like it to look in column "A" and look up for the
number 2 and then copy the row to a worksheet called "roundm"

Thanks in advance

Greg