filters

I need to understand the syntax and code to determine what filters are currently applied to a spreadsheet so that I can return the filters to the sheet at the end of my macro. I currently have a macro I created to copy and insert a row of data identical to the row your cursor is on. The first...

Good afternoon all, I have created a spreadsheet that uses drop down lists to control the data that is entered. A problem that I have encountered though is that I can not now apply filters to my headers. Does anyone know of a work around for this or is it a by product of using drop down lists...

In the dBase we use at work, that I have been working on for ever and a day, we have a lot of date filters built into queries. I was wondering if there is a simpler way to standardize them, so they all look similar, but perform the functions needed. They all need to be a greater than/equal...

Is it possible to search for several matching numbers when running a search from the Filter drop down dialog box or even with the 'Text Filters > Custom Filters' option? I tried putting a comma between each value but it didn't work. Thanks in advance.

Hello, I have a workbook with several worksheets and several advanced filters that was working very well, but with unknown reason the advanced filters stop working Below is a link for a test sheet from my workbook that shows how I did the advanced filter Can someone please check it and let me...

How to filter hunderds of lables in Excel Filters & from Pivot filters?. It is easy to filter one or two label values from filters / pivot filters, if i want to filter hunderds of labels in "Filters" or Pivot "Filters" in excel .. How to do that? It is very difficult to select many labels from...

I have to keep changing my filters with various date ranges and it's a real pain having to keep checking 20 boxes out of a thousand every time I want to change the range. Is there a way I can specify the dates I want to filter in, say, A1 and A2 (start and end range) and I see the new filtered...

Good afternoon! So I am trying to sat up an automatic report for my job where I can use advance filters to type the selected months into the criteria page and have it filter per those months. The macro however uses both Advanced and Normal filters and when I transition between, the entire table...

Hello, Self taught daily user that occasionally dreams that I have to VLOOKUP people before I can speak to them.. :eeek: I have many pivots per tab. I deleted the source data and replaced it with new data and refreshed all. Some of the filters did not keep, and some did. How do I lock down...

Hello, I have three pivot tables. The rows and values vary between each but the Filters are ALWAYS the same. I am looking for a way that when I update a filter on one, it updates the filter on the other two pivot tables as well so that I don't have to update each one manually. Thanks for the...

I am trying to calculate a global average of jobs performed per each engineer for all jobs after a set date. This number should not change at all as other filters/slicers are operated. I can get it stable for various column filters, but cannot get the date stable for some reason. My full...

I have the below code which will automatically reset filters when saved. However, I need this to operate in a Shared Workbook. How can I get the filters to reset when the workbook is saved, in a shared workbook please? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...

Hello All, I have recorded (that's all I can do :)) a macro that filters a set of data. At the moment it filters a set of vehicles and a set of locations. But my problem is that on daily basis, different vehicles may go to the location that is required. Thus I end up manually changing the...

Hello, I have data consist of invoices and additional informations. I am trying to make up a summary report from it. Example workbook is here: https://we.tl/t-sCoObV14x4 I manually copy/pasted cells based on those dummy filters but what I'd like to achieve is clear I suppose. Btw, user may...

is there any way that I can coloured the first two rows in a worksheet automatically after applying the filters?This is the overall problem :I have got a sheet with columns like thisitem price criteria1 criteria2I have to frequently filter and note down the price of the first two rows of the...

New to Power BI and trying to figure a way to generate graphs based on specific Top N (other than top 1) count conditions without adjusting filters. The idea would be to have it auto update based on new data each month without having to manually select filters. Example using meal choices out...

I am trying to clear the filters in the pivot tables. I removed the information in the main spreadsheet, but it still remains in my drop down in my pivot tables and is starting to become a big problem. I have tried taking out the report filter field -- removing the main filter than re-adding...

Sorry for this question, I'm sure it's super easy but I can't figure this out. I have a spreadsheet for all of my spend info. There are 924 rows, on row 907 I have a subtotal formula which is there to provide a sub-total when I filter the category column for a specific category (auto-gas for...

I have a data table and would like to filter out all items starting with an X, Y, Z I have tried using Text filters does not contain, but it only allows 2 criteria It would be appreciated if someone could kindly assist me

I have the following code to Clear Data form all Sheets named "CSA" Sub Clear_All_Values() Dim ws As Worksheet, sh As Worksheet Set ws = ActiveSheet If MsgBox("ARE YOU SURE YOU WANT TO CLEAR ALL AGENTS RESULTS?", vbYesNo, "CONFRIM") = vbYes Then Worksheets("CSA1").Select...