Macro to repeatedly find duplicate data

[Jack E]

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,

 

[Gary''s Student]

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.

 

[Fred Smith]

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]

Thanks that worked perfect!!

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.