Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...