#1   Report Post  
jc94321
 
Posts: n/a
Default Dynamic Date Ranges


One one sheet I have a time series of data sorted by month. How do I go
about (on a different sheet) using some sort of dropdown box (either
through data validation or a combo box), so that the user can select a
beginning date and end date, and the spreadsheet will display only the
information in that time period. The number of columns would have to
dynamically adjust I believe.

Thanks!


--
jc94321
------------------------------------------------------------------------
jc94321's Profile: http://www.excelforum.com/member.php...o&userid=27258
View this thread: http://www.excelforum.com/showthread...hreadid=467693

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
dependent drop down boxes and dynamic ranges philcud Excel Worksheet Functions 2 September 1st 05 01:03 PM
Indirect and dynamic ranges Sam Excel Worksheet Functions 3 January 24th 05 07:01 AM
dynamic ranges Sam Excel Worksheet Functions 2 January 21st 05 07:46 PM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 01:08 PM.

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"