autofilters

Hi there! First time posting here, you all have been amazing help while building out multiple projects. Really appreciate the community. I currently have two Pivot tables [PivotTable1 and PivotTable2] on a sheet("PivotTable"). I Have two Filters for each, one is Auditor, the other is Date...

I am using an auto filter criteria range, where the cells reference filter selections input on a different tab. For example, the cells in the criteria range have a formula similar to this: =if(Sheet1!A1="","",Sheet1!A1) However, if only 1 of the 4 input selections are chosen (which is often...

I have an autofilter setup with 3 values: "Show", "Hide" and "Always". The show/hide values are dependent if formulas based on other cells. I have two sheets with this filter (Template and Summary); the filter works fine on the Template tab, however on the Summary tab... When filtered to...

Hi all, I have 2-ish problems. First, I want to create a format that shades every other line grey in my worksheet - however, Excel won't let me do that because I am using AutoFilters. It says they must be disabled in order to format what I have, but I cant afford to undo them. So, I thought...

i want to automatic daily juornal or roznamcha gather current date data from different sheet to specifec sheet i am trying with advance filtering pivot table consolodating but still not solved my probem

Ok, This might be an extreme shot in the dark, but does anyone know of a way to change the color of the auto filters from that extremely dark blue to something that, ohhh i don't know, might actually stand out in a spreadsheet of many filtered items! The problem is when i'm looking for whats...