Create multiple worksheets and automatically enter data from list

[LeilaniMerle]

Hi,

I have a list in my Excel spreadsheet, and a template that I use to generate student Names, Surnames, Student Numbers and I.D.S. How would I get the relevant information into the correct cells and automatically create the worksheets, and possibly rename the worksheet to the Student Number.

P.S. I have blanked out I.D. Numbers and the names are fictitious for the purpose of confidentiality.

Thank you for any assistance..
Kind regards

Merle Tait

 

[LeilaniMerle]

No it will create a new sheet for every value in col A. Why not try it

I dont know how to change the ranges. I am getting a debug error.

 

[Fluff]

Why do you need to change the ranges?