1. S

    looping with Auto Filter

    Hi board, I recorded the following macro: Sub Macro1() ' ' Macro1 Macro ' ' ActiveSheet.Range("$A$1:$Q$2975").AutoFilter Field:=2, Criteria1:="2014" Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Application.CutCopyMode = False...
  2. A

    How to use Criteria1:="" to NOT TAKE multiple criteria

    Hello, So I have set 3 dates like this in excel: Dim TradeDate As Range Set TradeDate = ActiveSheet.Range("AA1") Dim TradeDate1 As Range Set TradeDate1 = ActiveSheet.Range("AB1") Dim TradeDate2 As Range Set TradeDate2 = ActiveSheet.Range("AC1") Then I have a pivot table...
  3. G

    Using a Wild Card in an Auto Filter

    Hello All... '**************** Build Zone 1 ******************** Sheets("Alignment").Select With Range("B4:AG1300") .AutoFilter Field:=12, Criteria1:="1-1" Range("B4:AG1300").Copy Sheets.Add(After:=Sheets(Sheets.Count)).Name = "Zone 1" Range("A3").Select Selection.PasteSpecial...
  4. I

    Search & Copy function based on criteria that EXCLUDES invalid entries

    Alright so I'm a good portion of the way through this, but I can't seem to solve one issue. The function is intended to search a defined column for a defined criteria and copy the whole row if it's found. The issue is that, in addition to copying the rows with the criteria, it also copies...
  5. I

    Search & Copy function based on criteria that EXCLUDES invalid entries

    Alright so I feel like I'm 90% there... there's one particular problem in the routine. Ultimately, I'm trying to increment through a dataset of 7000+ rows, search a defined column for a defined criteria, and then copy the entire row to a new sheet if that criteria is true within the searched...
  6. A

    Using VBA to Copy Paste onto another Workbook

    Hi I am trying to copy paste filtered data using VBA onto another workbook under 4 separate sheets but it doesnt seem to work Sub Macro1() ' ' Macro1 Macro ' ' ActiveCell.Offset(2703, 1).Range("A1").Select ActiveSheet.ListObjects("Table132415").Range.AutoFilter Field:=3, Criteria1 _...
  7. G

    VBA SumIFS error

    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...
  8. C

    Filter tables in the workbook

    Hi all, My tables retrieve entries from the database through a dropdown list so they can have 1 to 500 entries therefore auto filter to remove blanks is inevitable. I have tables across many sheets however they don't start from the same row or column. In order to filter out blanks, I had to...
  9. T

    Is there a way to determine the top 80% of a list using multiple conditions

    Here's a quick example...sorry for the formatting...but I don't have the tools to post html sheets...if someone could point me to what is being used these days i'll add it but essentially i'm trying to figure out if Running Value is top 80% of all values based upon the multiple criteria i...
  10. C

    Vba excel 2007 autofilter with one criteria which is a variable

    Hi... I'm trying to set the criteria field as not equal to my variable. I need the variable because this file will eventually be saved repeatedly as a new version with a different account number. I do not want to have to update code in each one. The code that I have works correctly to identify...
  11. M

    Problem using "contains" in Autofilter

    I'm fairly new to VB but I'm trying to write a program that is meant to do the following; XL file#1 Look in column D Copy first value (M123, I use a "mid" function to extract only the numbers.) XL file#2 Custom filter column J (Criteria1:="contains" previous value 123) Copy all visable rows...
  12. Yard

    Store active Autofilter criteria in array or range

    Hi all, I want to perform some operations (basically a secondary filter) based on the values which are currently filtered within a single filter column. .Autofilter.Filters(n).Criteria1 and .Criteria2 are great, but what if there are more than 2??? i.e. I have a column containing values...

Some videos you may like

This Week's Hot Topics