| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy validated lists
Making a schedule 21 days across by 12 rows down. I want to make a drop down
list of employees names and have the same list available in each cell. I use the data, validation steps to create the lists, but Excel automatically changes the coordinates of the data in each horizontal or vertical cell. How do I make an IDENTICAL drop down list of employees show up in each cell? This has frustrated me so badly that the dog assumes I'm going to kick him and hides everytime I open an Excel spreadsheet. (well, if I really had a dog to kick he would) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing copy/paste on validated cells | Excel Discussion (Misc queries) | |||
| Copy lists and paste them automatically | Excel Discussion (Misc queries) | |||
| be validated or not validated in a cell | Excel Programming | |||
| how do i copy drop down lists and paste them | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Threaded Mode
