|Hello i have little knowledge in Excel but i will explain in the most detail possible.|
When you load the excel workbook there is a master slide within this there is:
Drop Down List of Students Names
And a Add Student.
I have made the Drop Down list input range the columns "M" and "O"
What i would like is that every-time I write a new students name and press the macro.
It adds there name to the column "M" and then creates a new worksheet and titles it the student name you in-putted.
Any help would be helpful as im truly stuck.