create new sheets based on list of student ID numbers

[palaeontology]

Hi, I've watched numerous youtube videos on this topic but can't get my head around it.

I have a list of student ID numbers in .... 'Yr 9 Hw Data'!A4:A36 ... that's a maximum of 33 student ID numbers ... I can't envisage I'd ever have a class of more than 29.

I'd like to have a code that, when a button is pressed, generates a new sheet for any student ID number in the list. Importantly, I have a sheet I'd like to use as a template (for each of these new sheets) called ... 'new sheet template'

I'd need the new sheets to each bear the name of the student number it was generated for.

Obviously, if there are empty cells in the list ... for example if I only have 24 students and there are 9 empty cells at the bottom of the list ..... I wouldn't need a sheet generated for the empty cells.

If the button was pressed a second time, some months later for example, I'd need it to wipe out any existing student ID sheet, and make all new ones from the list.

Is this code possible ?

Kind regards,

Chris

 

[palaeontology]

so what should the final code be ... in its entirety ?

Kind regards,

Chris

 

[My Aswer Is This]

Use the script in post 8
But change this line of code:
Sheets("start").Copy , Sheets(Sheets.Count)
To:
Sheets("new sheet template").Copy , Sheets(Sheets.Count)

 

[palaeontology]

that worked perfectly ... thankyou to everyone who helped me,

kind regards,

Chris

 

[My Aswer Is This]

Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.

that worked perfectly ... thankyou to everyone who helped me,

kind regards,

Chris