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 ...

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...