filters

I have a listbox containing a list of files in a folder. I also have a Textbox1. I need a code that as soon as I type in the textbox1, it filters the file names in the listbox.

Hello, everyone, please for your assistance. I have made a VBA form in which there is TextBox1. I want to write something to find it in the selected worksheet named "Base" and column "P". (this part is most difficult for me to do). I mean - Text Filters -> Contains I would be very grateful if...

HI, I have tried both below options to either show all data or remove filters in preparation for the workbook to be reused but neither work. On top of this I would like to clear contents in range A:W down to last entry on one sheet and a different range on another sheet. Both are in tables but...

I have a macro that clears all filters which works great if there are filters to clear. Otherwise I get an error message. Sub ClearFilters() ' ' ClearFilters Macro ' ActiveSheet.ShowAllData End Sub What can I add so if no filters are selected it will do nothing?

Hi ,I want to SUM after applying filters on multiple columns Table 1 <tbody> ID Salary Level1 Level2 ID123 6 John Tom ID123 6 John Tom ID123 7 John Richard ID123 7 John Richard ID123 8 John Swetha ID123 8 John Swetha ID123 10 John Randy ID123 10 John Randy ID123 10 Ram Rocky...

Hello - is anyone able to help with the below without the need for having to create a macro. I have a pivot table with 2 Report filters and 2 columns (Date in column A and cashflow in column B). The 'Row Labels' heading of the pivot is in cell A4 and the date start from cell A5 downwards, with...

My goal is to highlight the cell when I have a filter active in the pivot table row & column labels. I have found the linked document below which shows me how to accomplish what I'm looking for in regards auto filters. What I would like to do is perform this same action in a way that functions...

Hi, I tried recording myself changing two date filters in a pivot table. The recorded macro does not work and returns 1004:unable to set the currentpage property of the pivotfield class. There are many pivot tables with the same connection and filters in my workbook an my aim is to change their...

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

Please can someone help...I want to be able to filter on a table and delete if the result is 'Yes' and then remove filters using VBA Ay help, will be greatly appreciated Thanks Rehmat

Hi I can't seem to find the code that would allow me to control a Power pivot Pivot table with more than 1 filter. I got it to work for 1 filter but not if there are more than one. Recording doesn't help. Normal pivot work as well. issue is only with Power pivots

I have a range of data with filters on. I have a macro that applies one of the filters and what I now want to do is just enter a "1" in Column A next to cells that are visible when filtered. I have tried having a variable and adding one to the variable to move to the next cell and also using...

Hello all, first of all sorry if the question has been replied, but I´ve tried to find the solution in the forum and I couldn´t. I have an excel file with a dinamic table that catch the data from an odc conection in the company server. The dinamic table hav several filters, and I should change...

I am a newby when it comes to working with VBA a Macros so please excuse my ignorance. I appreciate the help I have found on this forum. 64-bit operating system with Excel 2016 32-bit I have a workbook with 3 worksheets. Sheet one (Action Plan) contains a table with filters turned on that will...

I have multiple workbooks with each one filtered to show different data. I now need to combine them but when I use get and transform, the tables are ignoring the filters and showing the data without any filters applied. What am I doing wrong? Thank you Figen

I am trying to import a text file into Excel using VBA. I have the following code, but I get an error on this line:With ActiveSheet.QueryTables.Add(Connection:=sFileName, Destination:=Range("$A$1")). Sub Macro1()Dim obj As Office.FileDialog Dim objFileDialog As Office.FileDialog Dim...

I'm trying to create a button (on a form) which applies 2 different filters at the same time. 1. Only Show records which have the same 'BO' Number as the current record AND 2. Only Show records where 'Status' is Blank I've tired a few ways but I can't see to get it to work. Does anybody have...

Hey! I've seen this thread which seems to be what I'm after, but doesn't quite work for me... https://www.mrexcel.com/forum/excel-questions/593812-macro-autofilter-skip-if-blank.html When I use the answer here it skips even if there is a field present. Below is what I have, there are several...

I have searched the forum and could not find a resolution that works. I am a newby when it comes to working with VBA and Macros so please excuse my ignorance. 64-bit operating system with Excel 2016 32-bit I have a workbook with 3 worksheets. Sheet one contains a table with filters turned on...

I have filters on 100+ columns on many of my worksheets and I frequently forget to remove the filter when moving to another sheet. Then, when I return to that sheet, I can easily not realise that a filter is already in place, leading to all sorts of problems. I've been trying to automate...