| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need macro to remove duplicate rows in a wksht with same order#
I have and extracted csv file tha i need be able to write a macro that will
eliminate the duplicate rows with the same customer order number. Thanks, G2 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need macro to remove duplicate rows in a wksht with same order#
Use Advanced filtering:
Pull-down: Data Filter Advanced Filter€¦ Click copy to another location Click List range, clear it, and highlight your table Clear Criteria range or leave it blank Click Copy to and select an un-used area in the worksheet Click unique records only -- Gary''s Student "G2 in AUS" wrote: I have and extracted csv file tha i need be able to write a macro that will eliminate the duplicate rows with the same customer order number. Thanks, G2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need macro to remove duplicate rows in a wksht with same order
Bingo! Thanks so much, haven't had the occassion to use the Advanced
filtering until today. Powerful stuff I'm good to go for now "Gary''s Student" wrote: Use Advanced filtering: Pull-down: Data Filter Advanced Filter€¦ Click copy to another location Click List range, clear it, and highlight your table Clear Criteria range or leave it blank Click Copy to and select an un-used area in the worksheet Click unique records only -- Gary''s Student "G2 in AUS" wrote: I have and extracted csv file tha i need be able to write a macro that will eliminate the duplicate rows with the same customer order number. Thanks, G2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows | Excel Worksheet Functions | |||
| Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
| inset rows and copy formatting , excel macro | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
