Hi,
I want to count and sum of the autofilter data in sheet1 to sheet2
below is the code with erros msg -
sub addautofitler()
Dim Sh As Worksheet
Dim Rng As Range
Dim ws As Worksheet
Dim Cell As Range
Dim Unique As New Collection
Dim i As Integer
Dim rcount As Long
Dim esum As Long
Dim...