autofilter

Hi, I'm struggling with the below VBA. I have data In cells A6:S1176 and headings in cells A5:S5. I want to filter column A based on the value in B1. I then at the same time want to always filter out anything minus or below 0 in column G. When I run this macro though I get this error message...

Hi, I'm using Excel office 365. Weekly I import data into Excel then filter out certain items based on preset criteria. I do this using auto filter and a simple macro to delete the entire row. So for example, my import might look like this: <tbody> Date<strike></strike>...

Hi all, On Sheet2, I have a drop down that changes the work week to display that week's bookings. On Sheet4, I have an "Override Tab" where the users can input their weekly forecast and any corrections to the bookings. What I'm trying to do is get a VBA autofilter on Sheet4 that activates rows...

Good afternoon, finding myself in a "smash head on keyboard to continue"-situation. I'm filtering a dataset on various columns. In one it has to exclude all rows where the cell value in the column reads "Don't use". The cell contents are entered via a formula which looks in another cell. The...

Hi I have a table where I want to either show 'blanks' or show 'all'. The below code just keeps it on showing blanks. Can anyone help to add a filter if not applied and then show all / just show blanks based on field 5? many thanks in advance Private Sub ToggleButton1_Click() If...

ActiveWorkbook.Worksheets("Sheet2").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet2").AutoFilter.Sort.SortFields.Add Key:=Range _ ("AB1:AB97515"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With...

I have a large list of items that need filtered using 2 criteria. I currently have: q1 = sh2.Range("B11").Value If q1 = "Y" Then sh1.Range("A2").AutoFilter 10, "Y" ElseIf q1 = "N" Then sh1.Range("A2").AutoFilter 10, "N" End If What I need it to do is if cell B11 on sheet 1 is answered with "N"...

Hi everyone, Long time lurker, first time poster - I'm not great with VBA to begin with and I'm at my wits end, so I'm hoping someone can help me. I am trying to create a button on Sheet1 that, when pressed, will search for "X" in Column F of Sheet2 and copy the full contents of that row onto...

So I have been playing with If in my VBA, I have the below code that works perfect but I want to set an If function that will skip the section of code that opens and pastes data to my running file (I put lines sectioning the code I want to skip) if the autofilter does not have any data marked as...

Hi all, I have a macro which successfully runs activated by a button, to apply an autofilter. This is the code: Sub ReduceOPCList()' ' ReduceOPCList Macro ' Reduce OPC List ' ' ActiveSheet.AutoFilterMode = False With ActiveSheet.Range("B10:I72") .AutoFilter Field:=1...

Can anyone help me please? I’m new to VBA and I’ve written code to run an AutoFilter. It’s only a few lines and I should be able to see what the error is but just cant. It runs and it shows the headings and deletes the rest of the range. Sub StartEnd() Dim StDate As Long: StDate = (AO1) Dim...

Hi experts! I have a problem with trying to write a VBA code...have tried creating & looked around the web and have so far failed miserably with this. I am trying delete rows NOT starting with three letters - specifically HKG, BJS and SYD. The table looks like the below with the data being in...

Hi, Columns A:G in my spreadsheet contain "Yes" or can be blank and there may be rows where there is more than one "Yes". I have a dropdown in cell K2 where I can select the names of one of these columns and then I want to filter the data based on that column. There's probably a better way...

So I am sure everyone or most people now how auto filters work. I was looking into, I guess dynamic searching. So as you type in what you are looking for it preforms an autofilter. I was hoping someone would be able to explain how to do this, as well as, is it possible to have two of these on...

Hello, I have a spreadsheet with different skills listed as column headings in the table I named "Train". I would like to be able to double click on any of the column headings and have my table filter on all non-blank cells. The rows have trainings listed so the table is full of x's that...

I have a table that I need to omit 3 options and show 10 others and I do not know how to do that. I have tried an autofilter vba code but it will only filters on 1 of the criteria. Listed below is what I need to show and not show. Thank you for your help. Table6 is my table name Show - DA, FE...

Hi,# Could someone tell me why this isn't working? I can get it to work for non-dates (obviously changing the column in the autofilter to one that accepts the relevant values), but dates are proving a problem! Sub AM() Dim Root As String Dim DteAry() As Date Dim n As Long...

Requesting help with setting up a macro to autofilter multiple criteria, copying visible data only, and selecting and pasting sections of the data at a time into another worksheet in the file. Here is a previous post that works for single criteria...

I'm trying to write code to get filtering information for a worksheet. There are, of course, two possibilities: After auto-filtering with the drop-down arrows, WS.AutoFilterMode is True, and I can enumerate the AutoFilter.Filters collection. After an Advanced-Filter operation, WS.FilterMode is...

Hello all, I want to Create a sub of autofilter in VBA that will autofilter my range by a criteria that is written somewhere in my sheet, for example: I have a table: code|Pname|price| 1 aaa 10 2 bbb 11 3 ccc 12 4 ... ... ... and in cell A1,A2,A3 a list of...