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