Use data filtering. Filter column A for "Outflow". It will display only
those records. Now copy all visible cells. Done.
Do the same for "Internal". Spend the rest of the time on coffee break.

Regards,
Fred.

"Jack E" <Jack wrote in message
...
This is my data,

Column A Column B Column C Column D
Outflow 25 15 Broken
Internal 10 5 Dropped
Internal 20 1 Broken
Outflow 35 22 Broken
Outflow 21 7 Dropped

I need it to look in column A for "Outflow" , once found copy and paste
the
whole row in sheet2, then go back and look for "Outflow" again and repeat
until it doesn't find anything. Then I need it to start looking for
"Internal" , once found copy and paste into sheet3 and so on.
Any help it greatly appreicated,