Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like for a person to be able to select from two cells on a sheet to enter
a date range. I'd like for my pivot table date page field to then use those two end cap dates as the range for which to not hide items. Possible? In other words, right now, I have to ask the user to go into the field settings, deselect (for example) a month of dates and select another month, every time they want to change the scope of the table. I'd like to make it easier by forcing the table to just on its own take two cells and use a macro to use those dates as the start and stop of its range. If anyone has some code that can accomplish this, would mean a lot towards user convenience on this thing. Thx. -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert date field to month in Pivot table | Excel Discussion (Misc queries) | |||
Pivot table with a variable range in the sourcedata field | Excel Discussion (Misc queries) | |||
pivot table date field | Excel Worksheet Functions | |||
Field , Date range and Sum from worksheet import | New Users to Excel | |||
Pivot table will not group a date field | Excel Discussion (Misc queries) |