Excel Make a Macro Add a new Work Sheet

Microsoft Microsoft excel 2007 full vers...
January 18, 2011 at 09:49:50
Specs: Windows Vista
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.


See More: Excel Make a Macro Add a new Work Sheet

Report •


#1
January 22, 2011 at 19:39:12
re: "And a Add Student."

What is a "Add Student"?

re: every-time I write a new students name

Where are you entering the new student's name?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question