Forum Discussion
Solved
Creating a Roster
Is there a way to automate building a roster (Roster worksheet) from the Drop Down list created (from Sheet1). I now cut and paste each name and place it in the cell as I select it. What I would like...
- This is fantastic. I just started taking a comprehesive course on Excel. But I never would have been able to do this. Many thanks.
I've never done anything like this before. I entered the code in Sheet1. I believe I've done everything through saving the workbook. I'm not sure how to allow macros.
The code should go into the worksheet module of Sheet2, since the dropdown is on that sheet.
See the attached version. If you get a warning that macros have been disabled, click to allow them.
- Hello Hans,
I noticed in my Roster, when it adds a name to the Roster, the Drop Down list is still associated with the name (I see the Drop Down arrow in the cell). Is it possible to just have the name appear?marty007 That's an artefact. Simply remove the data validation rule from column B. The code doesn't add it.
- That did it, thanks again.
- This is fantastic. I just started taking a comprehesive course on Excel. But I never would have been able to do this. Many thanks.