ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dynamic Date Ranges (https://www.excelbanter.com/excel-discussion-misc-queries/45443-dynamic-date-ranges.html)

jc94321

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



All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com