Thanks that worked perfect!!

"Gary''s Student" wrote:

You can use AutoFilter:

1. Make sure you have a header row
2. Click on a cell in the header row and:
Data Filter Autofilter
3. Click on the pull-down and pick Outflow
4. Copy the visible rows and paste them to sheet2

repeat 3 & 4 for the other values.
--
Gary''s Student - gsnu200835


"Jack E" wrote:

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,