VBA Code to duplicate (create copy of a sheet) sheets?

Dear friends,

I am a teacher and tryng to create a solution to mintor progress of my students whil they are working on the projects. The project monitorng/marking is based on different strands.

I entered all the strands on sheet (Data) the way I want them to be.

On second sheet (Students) I entered student names.

Now I want to put code to generate one copy of the sheet containg marking/monitoring table (data) for each student.

Each copy must be named after the student,,,,,

I will be obligd if you please help me.

Regards

Hi,

Without an example is a bit hard to see what your doing.

Sounds like Ron's site might help

http://www.rondebruin.nl/copy5.htm


VBA Noob

Hi,

I'm not a VBA expert but here is my crude code

Please Login or Register  to view this content.

NB Start is a name range for cell B8

VBA Noob