autofilters

  1. B

    VBA Auto Filter Multiple Values in a PivotTable

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

    Auto Filter where range includes cells with a value of ""

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

    AutoFilter not recognizing values

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

    **Print Area Macro OR alternative solution! :)

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

    i want to automatic daily juornal or roznamcha different sheets

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

    Changing the color of Autofilters

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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top