This works perfectly. Thanks so much for the advice
I am a beginner at using VBA and Macros. I have a Master roll with students scores for each assessment for every subject. I have managed to create a macro that copies the template to a new worksheet and renames the worksheet to the student number. I need help on how to create a Macro that allows me to populate the necessary information from the master roll to each individual student worksheet. This is not for work - I am just practicing to improve my skills.