Can someone help with the below code, i know ive got the syntax wrong on the remove duplicates line but cant work it out??
Dim AMStart As Long
Dim AMLast As Long
AMStart = .Range("I" & .Rows.Count).End(xlUp).Row
AMStart = AMStart + 3
Range("I1:L1").Select
Selection.Copy
Range("I" & AMStart).Select
ActiveSheet.Paste
AMStart = AMStart + 1
Range("F2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("I" & AMStart).Select
ActiveSheet.Paste
Application.CutCopyMode = False
AMLast = .Range("I" & .Rows.Count).End(xlUp).Row
ActiveSheet.Range("I" & AMStart & ":I & AMLast").RemoveDuplicates Columns:=1, Header:= _
xlYes
End Sub
Bookmarks