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.
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.
This is fantastic. I just started taking a comprehesive course on Excel. But I never would have been able to do this. Many thanks.