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

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

Highlight your two column headers. Click the options on the Home tab's Font selection of the ribbon and make the column headers stand out with boldface, shading or different fonts. This is optional.