Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

I have a relatively simple Excel task (I hope). One workbook, two sheets (Sheet1 and Sheet2) Sheet 1 has a dropdown Data Validation list that has 30 options. The user will choose an option from the ...