Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table input selection criteria
I've searched high and low and cannot find the answer to this ver simple question. I have a pivot table where one of the page fields is a date.:confused I want to allow the user to enter a from AND to date and then displa my pivot table for that date range entered. I know they can selectively do this through the drop down clickin specific dates, but I want specifically from and to range. i.e. Wher they enter in a date range. I want other page fields to be selected as from and to also. I wan this selection to be outside of the pivot table iteself. Does anyone have code for this. I have attached my sample spreadshee that shows what I am trying to do +------------------------------------------------------------------- |Filename: pivotexample.zip |Download: http://www.excelforum.com/attachment.php?postid=4648 +------------------------------------------------------------------- -- colmansprin ----------------------------------------------------------------------- colmansprint's Profile: http://www.excelforum.com/member.php...fo&userid=3358 View this thread: http://www.excelforum.com/showthread.php?threadid=53361 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Selection | Excel Discussion (Misc queries) | |||
pivot table selection | Excel Worksheet Functions | |||
Date Selection for Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple Pivot Field Selection | Excel Programming | |||
Pivot table selection | Excel Programming |