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!