autofilter

Hi all Ive been having some errors with this part of my code in bold. as i have this code run for 4 different sheets, each sheet will come back with different data, some sheets even with no data. this code works fine on 1 sheet, and the rest keeps getting stuck at the bolded part even though...

Hi, This is a bit frustrating. I've applied code to filter data using the autoFilter function but when I apply a new line with AdvancedFilter it appears it clears the filtered range and copies over all data With Sheets(1).ListObjects("Table13256").Range.AutoFilter Field:=22, Criteria1:="<>"...

Hi All Just a quick one - can I check the error handler covers all my autofilter criteria? I can't avoid the errors occurring on any of the criteria, I just want to skip over. Sub DataRaw() Sheets("DataInput").Select On Error Resume Next Selection.AutoFilter...

Hi Guys I have data in two columns and would like to delete data in the second column which has the letter 'N' in it, using the auto filter. The amount of rows will vary. In the example below, there are only 5 rows and I would like to delete rows 3 and 4, as they're the rows with the letter...

<code>Hi gang - I need some help.....I'm doing an autofilter and want I want is that if the filter doesn't come up with any results, then I want to unfilter. If it does come up with a result, I want to copy the data in column H onto a different sheet. What currently happens with my below code...

I have the following code which sets a range based on data being in the last column, however after running the autofilter a few lines later, the rows meeting the criteria have no data in the last column and are not copied to the new sheet. How could i get all the records after the autofilter...

Hi, I have an autofilter on row 13 and then trying to delete all the visible rows I found somewhere that the below code should work, but it doesn't. Anyone who could help me crack the code? Thanks, Jos Rows("13:13").AutoFilter Field:=5, Criteria1:="22 - Rabobank 370113144" .Offset(1...

how can i change the code below to activesheet instead of referencing sheet name so i can use in other sheets and don't have to change sheet name everytime. Sub ApplyFiters_Accrued()With Worksheets("OCT").Range("A3") .AutoFilter Field:=5, Criteria1:="" .AutoFilter Field:=9, Criteria1:="COGS"...

Hello, I want this Macro to filter off less than or equal to, not just equal to. Also, if one of the cells is blank (B2 or C2) I would like it to show 'all' for that selection, rather than 'none.' Can anybody help me? Private Sub Worksheet_Change(ByVal Target As Range) Set Target =...

Hi All Just wondering if the below code can be modified to exclude certain text from a filtered list as opposed to having to list all the text that you do want selected? Current code which will select C: ActiveSheet.Range("$A$1:$AA$11").AutoFilter Field:=3, Criteria1:="C" Cheers, KiwiDD

Hi, I'm trying to leave certain cells/functions open for user input, but keep running into a problem I can't figure out. I've been through endless forum threads, but none has been able to help me so far... I have a workbook with 4 sheets, two of which are VeryHidden and not relevant. The third...

There are headers in the top row for all columns. There are no gaps between columns. Columns A, B and C are frozen. I put autofilter on and it's fine. Then sometimes after I have been merrily using the spreadsheet for a while I notice that columns A and B are not in the filter. This is...

I've read several posts about how to use autofilter with more than 2 criteria and the answer seems to be to use an array - I am trying the following but get a Type Mismatch error on the Criteria 2 line? Criteria1 = "*Meeting 1*" Criteria2 = Array("<>*at their Stand*", "<>*Table...

Need to AutoFilter based on a range of values, such as: Worksheets("Sheet2").Range("A1:A5").Value When the range code is inserted into the rest of the VBA code, such as: Worksheets("Sheet1").Range("$A$5:$C$100").AutoFilterField:=2, Criteria1:=Worksheets("Sheet2").Range("A1:A5").Value The code...

Hi there, I'm a long time listener (reader) first time caller (writer). I have scanned through dozens of forums and topics but can't seem to find a working solution for this challenge: I have a table with multiple rows where I'm trying to autofilter a specific column based on 2+ inputs in...

Is it possible to autofilter a data table and the adjacent data using the one filter? I'm after a similar result to inserting a column before a pivot table and autofiltering that column, which then applies the filter to all used columns, including adjacent data.

I'm trying to copy the results of an autofilter, with the code below but keep getting a run-time error '1004': Unable to get the SpecialCells property of the Range class. How do i fix that? thanks! Dim LR As Long Dim rng As Range With Sheet1 AutoFilterMode = False LR =...

Hello all, If I have the following line of VBA, can I make the "AutoFilter Field:=7" number dynamic? ActiveSheet.Range("Data_column_headers").AutoFilter Field:=7, Criteria1:="=" Ideally I would place my named range in there as my columns move around. Thanks!

Hi! Ran into a silly issue, but not sure how to get past it. I have value in cell "N10" with 2 decimal places (from SUBTOTAL formula, but manual entry makes no difference). I also use "European" numeric system with comma as the decimal separator (instead of dots). This decimal separator seems...

I have the below code and I get an error when trying to run it I get the error Run-time error '1004':Autofilter method of Range class failed This is because after filtering sometimes I have no results. I would like to have a code that tells to ignore the code if the Autofilter returns no...