View Single Post
  #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