Great! Thanks for letting me know.

Paul wrote:
Amillion thanks, Debra. Neat, simple solution, and your explanation was far
more understandable than umpteen searches through Excel's Help section. May
you always be happy and healthy! Paul.

"Paul" wrote:


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)



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html