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,
|