Excell 2003 Advanced Filter Unique Items

Closed
TK - Nov 19, 2009 at 04:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 19, 2009 at 08:38 PM
Hello,
I am using the Advanced Filter to identify the unique items from four columns and paste into four new columns on the same tab.
The problem is that the first filtered unique item is being repeated as the last filtered unique item. Obviously I don't want any item to be repeated. What is causing this and how do I correct it.

Side note:
The Advanced Filter function is part of a simple macro that consolidates the information from 13 different tabs onto this one tab where the Advanced Filter then grabs only the unique items and copies them into new columns. The macro is doing everything that it should be doing, but the filter results are not 100%.

Here is the code for the filter command within the macro:
Range("A2:D7800").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"F2:I7800"), Unique:=True
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 19, 2009 at 08:38 PM
advance filter required collum heading try to change to

Range("A1:D7800").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range(  _
"F1"), Unique:=True
3