How to Improve Your Excel Spreadsheets With Data Validation
Have you ever seen an Excel spreadsheet with a dropdown list in it and wondered how it was done? This is data validation. Data validation improves the data in your spreadsheets. It makes reporting much easier as there is no risk of typos and no risk of an entry not fitting into your criteria. In this blog we will take data validation a step further and look at how to make one drop-down list change its values depending on the choice made in a previous drop-down.