Alex J_Dynamic Data DV0055 - Dependent Data Validation Click Combobox -- Click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled.
List in second column is dependent on selection in first column.
Data Val Combobox_Add Sort_DV0061 - Assign Players Each Inning -- Select a player from a dropdown list in this Excel template, and that name disappears from the other dropdowns for that inning.
Excel 2010/2013: Data Val Player Innings2013DV0059 - Add New Items to Validation List -- In a workbook with multiple data validation lists in Excel tables, type a new value in a cell that contains data validation, and confirm that you want to add it to the drop down.
Summarize task data in pivot tables, to see total times.
Format: xlsx Macros: No Size: 23kb Download: Instructions: N/ADV0068 - Show Data Validation Input Message in Text Box Click a cell that contains a data validation list, and an Active X text box appears on the worksheet.
Lists are stored in named ranges on a separate sheet. Data Val Combobox DV0056 - Dynamic Data Validation -- With this data validation technique from Alex J, users can see a drop down list with just the top projects, or all projects.
A macro cleans up the selection cell, if necessary.Then, click OK, to add all selected items to the cell.Lookup lists are in named ranges on different sheet.Must not be greater than production time, and drop down lists control the valid times.Format: xlsx Macros: No Size: 18kb Download: Instructions: Excel Data Validation - Select Hours and Minutes DV0070 - Option Buttons Control Drop Down List Click the option button for a region, and the data validation drop down shows list of colors for the selected region. Format: xlsx Macros: No Size: 22kb Download: Instructions: Option button setup DV0069 - Excel Project Task Tracker List project tasks, estimated time, person assigned, date completed, actual time, and other task information.Three are used to create the basic framework of the method.