label filters

  1. C

    Find item x in a list VBA

    Hi I want to control a filter in a pivot table with some VBA. The data is a date but displayed in the following format yyyymmdd and is represented as a number. The pivot data looks roughly like <tbody> Date Data 20140201 1 20140201 2 20140201 3 20140202 2 20140202 4 20140202...
  2. T

    Change Label Filter for Every Pivot Table

    I would like to be able to change the label filters for every pivot table in a workbook to the values in specific cell references. The label is a date range between yrmo1 and and yrmo2. I need some sort of VBA looping routine. Basically, I want to just change the cell values once, hit a...
  3. J

    Pivot Tables - Label Filters 'greyed out'

    I constructed a simple pivot table on sperate sheet based on info on another sheet. One problem I ma having is the 'Label Filter' is greyed out. Does this have something to do with the fact that some rows on my data sheet are hidden? As well how can I unhide these hiddne rows, since...
  4. D

    Label Filters, Pivot Tables & Formulas

    I have created a pivot table from cube data in Excel 2007 that shows revenue by company for 2007 and 2008. I have the Year as my columns and wanted to create a label filter using a formula so that it grabs YTD information: i.e. Full Date is between '2007-01-01' and '2007-11-19' However, I...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top