![]() ![]() ![]() In this method I use dynamic named ranges and some VBA code activated from the worksheet to get the job done. This is one way that I work with multiple lists dynamically. In this tutorial we will use some VBA code to change the data validation depending on what is selected from a drop-down list. ![]() ![]() In the previous tutorial we demonstrated how you can make multiple lists dynamic by using the tables feature that is built into Microsoft Excel. This is the second of 4 tutorials to show how I deal with multiple lists in Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |