Macro to repeatedly find duplicate data
 

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,

Macro to repeatedly find duplicate data
 

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,

Macro to repeatedly find duplicate data
 

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,

Macro to repeatedly find duplicate data
 

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,