filters

Hi. I need to create several pivot tables that share most of the row and columns, only the filters change. With regular pivot tables, I could copy the whole pivot, paste it and then change the filters. With Power Pivot, when I copy the whole pivot, it is linked to the original, and if I...

Hello, I have one sheet with so many data (usually more then 30k rows) and I have to make macro that delete every row that meet condition that in column C is different then conditions are = to 53 specific and always the same different text values. I know that i has to do something with setting...

Hi, I have a file with a table that I have also created a graph to go with. When I created the chart, it looked great, but as I filter the data the legend changes. It will go from markers (which is what I want to show) to lines or just not have a marker or a line. Is there a way to set the...

Hi I have an excel workbook with multiple tables in there The reason why i have tables is that i have the ability to have mutiple filters whereas normal filters only allow you to have 1 filter so cant have multiple filters on 2 data sets on same sheet which is what I need How can i share...

Hello, I have written some VBA code but part of the code unlocksand then locks a spreadsheet again once the code has run. The idea behind thisis so that users aren’t able to mess with the raw data / delete entries withoutgoing through the correct procedure. There is however a requirement to...

I'm not sure why this is happening, and you guys helped me with this original code... but whenever I run this macro, it is ALWAYS trying to filter the first column when the any cell left of AS1 is selected. I have done some modifications to the original, but can't figure out why it's doing it...

Dear excel boffins, I have a macro that filters some rows out based on a cell being less than zero. 99% of the time, that's fine. There is on occasion a reason to unhide 1 or 2 of the hidden ones. Ill explain in more detail below. <tbody> CompanyX Xcode 1 -1 CompanyY Ycode 0 2 CompanyY...

Is ther some way to protect a worsheet so ppl can not write/delete data but still can use the colum filters to sort and search?

I sent an excel file to my coworkers with a pivotchart. The chart has filters but some of my coworkers when they open excel can not see the Filters. Is there a setting somewhere in Excel that I can share with them to check to see if this makes the pivot chart filters display so they can use...

Hi Forum, I have a table containing data A2:K173, there could be more rows added so it could grow to A2:K400. Row 2 is the table headers. What I want to achieve is in Cell B1, someone can write a number or product code and then the table filters by that product code. All the product codes are...

Hi all, So I have a file that when I hit the CLEAR ALL FILTERS button it makes my Excel window hang/freeze. I can still click around, save the file, etc but without any visual reaction (if that makes any sense) - I can't really see what I'm doing. Any idea why this happens or how can I fix...

Hi, I have the below code which clears the slicer filters fine but for some reason isint working on the timeline filters. Would anyone know what I need to add to clear the timeline filters? <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

Hello Group, I'm having a problem I hope somebody has a solution to I am working on a macro that copies data from a pivot table to a new sheet then sorts the data from largest to smallest then filters the data. Everything works fine until I filter the data. After it filters, I lose the sort...

Hi All, I have a workbook which has circa 30 tabs and is accessed byapproximately 25 users simultaneously. I’m looking for come coding to remove any current filters and unhideany columns then re-protect each sheet on opening. I have the following code which is removing the filters but...

Hi, I have data source from A1 to D200 My pivot table is positioned on G5. When I use filters on data source, my pivot also changes. Is there some way to have pivot show data from the unfiltered data even when I use filters? Thank you

I have a excel spreadsheet with filters when someone saves it with a filter on it messes up the file. Does anyone no what code Ican use so when someone goes to save the file it shows "have all filters been removed? yes goes to save and no cancels the request? thanks

I'm wondering if there's a simpler alternative to combining two CALCULATE statements. In our Accounts Payable file there are two ways of getting the paid amount. (Hey, I didn't design the thing.) Under most circumstances we can do SUMX(Vouchers, [Unit Price] * [Quantity]). However, certain...

Hi guys - grateful for any assistance you can give. I have done this before via VBA but can't recall exactly how. I have a worksheet with various headings, as below. I want to have data filters available on some headings, but not others. For instance: Columns A, C, D & F, but not visible on...

Hi, I have the below code that filters a pivot table based on a cell value but if the cell value is blank it errors out, not sure what I'm doing wrong as it seems simple - any help appreciated. Private Sub Worksheet_Change(ByVal Target As Range) ' Filters Pivots table on Market Name If...

OK. I have a fairly simple worksheet which I have two buyers sorting to see what parts they need. I then need it sorted a different way, so there are 3 ways this sheet needs to be searched. The sorts for Judy & Sara work. The sort for Jon/Default works...the second time. The first time it...