I am building a spreadsheet for office use. I have roughly 50 drop down lists on a spreadsheet (Sheet1) that are used for employees. The corresponding list (input range) of employees are in column "C" on sheet 2. Every time a new employee comes, or one leaves, I have to manually change the input range of all the drop down lists. What I want to do is have a command button on sheet 2 so when the user needs to add an employee, they can push the command button and an input box will pop up asking for the name. I then need the code to update all of the drop down boxes as well as column C, putting the name in ascending order (alphebetical). I would also need a command button to delete employees. I would include a sample of the spreadsheet but for employee confidentiality, I can't. If anyone knows how to accomplish something like this, your help would be greatly appreciated.(I realize this is somewhat of a database but Access was unavailable at the time this was created). Thanks

You said "Access was unavailable at the time this was created"...is Access available now? For if it is, you will way ahead of the game by using it. You can import Excel files into Access which will eliminate the problem of capturing all you existing data. As you said, this is a database project; therefore, using Excel is doing it the hard way. As to how to do it in Excel, don't have any suggestions there. Could be a big hurdle to get over.

Start recording a macro, and do all the things you do usually and stop recording after you are done. Goto macros and select the new macro and goto step into. Change the code according to your need and assign a macro.