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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top