criteria2

a macro reads the filtering selected by the user of an excel data file. When the user selects from a date column, using the tree list to select years, I can record a macro that simulates what has been selected as: ActiveSheet.Range("$A$3:$T$179896").AutoFilter Field:=4, Operator:= _...

The macro below works fine upto and including Criteria2. I manually added Criteria3 using Criteria2 as a template. It does not work. What syntax am I missing ? Thx Sub X_3B() ' ' X_3B Macro ' ' Range("F4").Select ActiveSheet.Range("$A$4:$AD$150000").AutoFilter Field:=6...

hi all, I'm trying to loop through several rows and columns using application.worksheetfunction.sumifs. Here is the segment I'm having trouble with: Dim lcol As Long Dim rrow as Long Dim SumRange As Range Dim Criteria1 As Range Dim Criteria2 As Range lcol = Cells(1...

Hi, I'm getting an error running this code, can anyone help me by pointing out why? Dim SumRange As Range Dim CritRange1 As Range Dim Criteria1 As String Dim CritRange2 As Range Dim Criteria2 As String Set CriteriaRange1 = Range("C3:C" & LastRow) Criteria1 = Sheets("Forecast...

Hi, how can I add 4 more variable criteria to this code, is it possible? ActiveSheet.Range(Range("A2"), Range("R2").End(xlDown)).AutoFilter Field:=1, Criteria1:=ThisYearID criteria2 should be :ThisYearID-1 criteria3 should be :ThisYearID-2 criteria4 should be :ThisYearID-3 criteria5 should be...

Hi, I cannot find a solution for my problem. Is it like this: <tbody> A B C D E F G H AB H1 0 TEXT1 CRITERIA1 A= AB AB J5 40 TEXT2 CRITERIA2 B= J5 AC R5 5 TEXT3 CRITERIA3 C= 40 FG H9 3 TEXT4 AB J5 40 TEXT5 MATCHES= TEXT2 AB J5 20 TEXT6 TEXT5 HZ D5 6 TEXT7...