dynamic list

  1. D

    Filter Out Duplicate Info Onto a different Sheet

    I'm using MS Excel 2000. Is there any way I can use autofilter and data validation list to sort and filter information (from a different sheet from other than orginal) and dynamically update and display it on another? Scenario: I have three sheets, one called Dashboard, Summary of All, and...
  2. S

    Data validation list limited by choise in other list

    I need to input a start year and an end year using data validation lists. The time span is 2010 - 2020. The first list is easy, but I would like the second list (end year) to be defined by the start year. If for example 2015 has been chosen as the start year, it should not be possible to...

Some videos you may like

This Week's Hot Topics