Re: How do I copy validated lists

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 spread***. (well, if I really had a dog to kick he would)



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

.