Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Duplicate data | Excel Discussion (Misc queries) | |||
How do I find duplicate numbers in a data? | Excel Worksheet Functions | |||
Macro - Copy and Paste repeatedly skipping cells | Excel Discussion (Misc queries) | |||
How do I repeatedly find text in an Excel sheet? | Excel Worksheet Functions | |||
Creating a macro to find duplicate names | Excel Discussion (Misc queries) |