LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 142
Default Pivot table with start and end date selection option.

Hi,

I have a pivot table with some data. The data has a start date and an
end date.
Is there a way to control dates using pivot table by having a data
validation drop for start & end date and getting results in piovt
based on that.
Would appreciate if one can also drill the data between the date
ranges.


Thx.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
preserve formatting option in pivot table option dialog box Dave F Excel Discussion (Misc queries) 4 May 8th 08 07:25 PM
Specify pivot table to hide 'earlier than' grouped data start date KenY Excel Programming 2 May 29th 07 09:43 AM
Start Date And End Date with pivot tables? Mark J Excel Programming 1 March 12th 07 04:28 PM
Start & End Dates in pivot table AngePaton Excel Discussion (Misc queries) 0 January 4th 05 11:01 AM
Date Selection for Pivot Table Burak Emer Excel Discussion (Misc queries) 0 December 15th 04 08:19 AM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"