| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to create identical dropdown lists in large blocks of cells
I use an excel spreadsheet to create a 4 week schedule for 20 nurses. They
work a total of 13 differant shifts. (7a-11a, 7a-3p, 7a-7p, 11a-3p, 11a-7p, etc). I'm looking for a way to create identical drop down boxes with a list of the available shifts for a large group of cells. So far, I have to do each cell individually via the "Data, Validation, List" route. That's over 550 individual cells I'd have to program one at a time, which is just not gonna happen. Anybody have a faster way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I create drop-down lists with references in other workboo. | Excel Worksheet Functions | |||
| How do i create an automatic monthly cash flow from lists of cost. | Excel Discussion (Misc queries) | |||
| create dropdown menu using Combo box | Excel Worksheet Functions | |||
| create dropdown menu | Excel Worksheet Functions | |||
| How can I create a table of contents(worksheets) for a large work. | Excel Discussion (Misc queries) | |||
Threaded Mode
