Dear all, I have recorded a macro that is for copy unique value form one sheet to another sheet . Here is macro that I recorded , it works very well for my case but problem is that it is very slower .Would you please help me with faster macro ?
Sub tsgmac()
'
' Macro2 Macro
'
Sheets("tsg").Select
Columns("A:A").Select
Range("A1:A34455").AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("test").Select
Sheets("test").Name = "test"
Range("A1").Select
ActiveSheet.Paste
End Sub
' please note that the range Range("A1:A34455") is not fixed as it may vary based on data that i will past manually
Bookmarks