| 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, |
| 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) | |||
Threaded Mode
