Sorting unique values and returning values from a formula

[MarcusA]

I have a macro to sort unique values from one worksheet to the next. My
macro retruns the formula from the range of cells vs. the values which I
need. What would I need to change in the macro below to list the unique
values instead of the formulas?

Sub unique()
'
' unique Macro
' Macro recorded 2/17/2006 by andersma
'

'
Sheets("Conversion").Range("G1:G3000").AdvancedFilter
Action:=xlFilterCopy, _
CopyToRange:=Range("C1"), unique:=True
End Sub

 

[Jim Cone]

Marcus,
Try it after adding a column title/heading in G1.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


I have a macro to sort unique values from one worksheet to the next. My
macro retruns the formula from the range of cells vs. the values which I
need. What would I need to change in the macro below to list the unique
values instead of the formulas?

Sub unique()
' unique Macro
' Macro recorded 2/17/2006 by andersma'
Sheets("Conversion").Range("G1:G3000").AdvancedFilter
Action:=xlFilterCopy, CopyToRange:=Range("C1"), unique:=True
End Sub

 

[MarcusA]

Thank you!!! it worked.