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