Untested

Sheet1("C:C").AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Sheet2.Range("A6"), _
Unique:=True


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nena" wrote in message
oups.com...
My goal is to autofilter the data in Column C Sheet 1 and have the
results placed in Column A Sheet 2 but it is not working, what am I
doing wrong?

Sheet1("C:C").AdvancedFilter
Action:=xlFilterCopy,Sheet1:=Range("C:C"),
CopyToRange:= Sheet2.Range(_"A6"),Unique:=True

Thanks in advance.