| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique Filter Macro not working correctly
The folloiwng macro is intended to look at a list of numbers in column "M"
and copy unique records only to column "B". But I'm still getting duplication in column "B". Macro: Sub Macro1() ' copy unique Work Order numbers to columb "B" Range("M6:M200").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "B6"), Unique:=True End Sub column "M" 73369 73369 73369 75817 75817 results in column "B" 73369 73369 75817 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro not working correctly | Excel Discussion (Misc queries) | |||
| Filter (blanks) with two or more unique values not working | Excel Discussion (Misc queries) | |||
| Adv Filter - Unique Items NOT working | Excel Discussion (Misc queries) | |||
| Advanced Filter not working correctly in macro | Excel Programming | |||
| Filter for Unique Values not working | Excel Discussion (Misc queries) | |||
Threaded Mode
