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.