Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Burak Emer
 
Posts: n/a
Default Date Selection for Pivot Table

I build some pivot tables for our laboratuary. They contains daily analysis
results. I want a solution to:
1-) User can enter week number and then daily analysis for that week appears
day by day on a pivot table.
Example: Input: 49 Output:29/11/2004--- 05/12/2004 on pivot table and
regarding data
2-) User can enter month and than daily analysis for that month appears day
by day on a pivot table.
Example: Input 11 Output:01/11/2004---30/11/2004 on pivot table and
regarding data
Thanks a lot
Reply
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
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM
Problem with Date format from VBA code twig Excel Discussion (Misc queries) 3 December 7th 04 06:01 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM


All times are GMT +1. The time now is 03:41 AM.

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

About Us

"It's about Microsoft Excel"