Pages Generated by Number of Participants

Firstly I hope I am posting in the appropriate Forum as I am guessing that the answer to my issue will involve some sort of formula.

This is not so much a problem, rather a how do you do it?

Basically I have a front page where you can input a list of participants in a course (1 to 20) and these names and associated information will populate other pages (course score, exam marks etc) and give an overview of the course as a whole.
What I would like is to also generate an individual final page for each participant that shows their final score and grade etc (taken from the other pages). So if there were 4 participants, it would generate 4 final pages and if there were 5 participants it would generate 5 and so on.
I am pretty sure I know how to populate these pages with the info, I am just unsure how to generate them based on the number of participants.

Thank you

Originally Posted by pjwhitfield

Just to confirm, when you're talking about "pages" you are meaning worksheets (tabs in your workbook)?

Are you wanting the sheets creating with the data in or do you want them to contain cell formulas/ references to the other workbooks so that they can update automatically?

Sorry for my bad explanation, yes I want it to create extra Tabs in the workbook for each participant. The data on these extra tabs would be taken from the other pages in the workbook, and there would also be the option of filling in certain data manually on the extra tabs.

Thank you for the reply. The Code you have posted above, where would I input this into my workbook?
I am learning Excel as I go and will try to edit it to fit my workbook, but I don't know where it goes initially.

Thank again

Thanks again for the reply. I have had a look and tried to input the code but I can't seem to get it to work, its probably because my original explanation was more basic than the workbook is.
I have attached the workbook and the tab Course participants is the tab with the names on it, that I would like to make the individual tabs for.

If you could have a look and provide anymore advice I would really appreciate it.

Thanks again

Attachment should be here

Thank you for the reply and help, I really appreciate it. I had a look and this is pretty much what I need it to do.
Is there a part of the code I can change that would make the new tabs appear at the end of the workbook.

Also one last thing, when the pages appear they are empty sheets, how do I input formula etc into these sheets so that when they are created they automatically take data from the rest of the workbook.
At the moment I cant edit them until they are created.

Thanks again for the help.

Thanks, that looks like it will do the job.
I will try to edit how I need it, and if I come across any issues I will post back here.

Thanks again.

I have had a play about with it but I am having a small issue (it could just be my lack of excel knowledge).
At present the Template you so kindly made puts the participants name in cell C2. If I wanted this in a different cell what part would I need to change, I have tried changing several parts that I thought would do this but it has had no effect. I am sure this morning I managed to do it but didn't save that version as I was just testing ideas.

Thanks again

Any help with the above would be appreciated.

I have put the formula below, I assumed changing the $C$2 would be the part to change but it doesn't seem to do anything. Being new to Excel and learning as I go the formula side of things is quite confusing.

Thanks for all the help so far.

=VLOOKUP($C$2,'Course Participants'!C5:D12,2,FALSE)

Think I solved it. It was not in the formula but in the VB code.

Another request for help. I have edited the template sheet to the basic layout I am looking for, however I need it to fill more cells with data from other sheets.
For example the 'Merit Position' cell on the template needs to have the corresponding data from the 'Merit Position' cell on the Grade report sheet.
If someone could show me how to make a second Vlookup request, I am guessing for any subsequent requests I could just copy and paste the code and change the cell data that the code references.

Hopefully my explanation makes sense, if not please ask and I will try to explain a little better.

Attached is latest version of the file.

Thank you

Having trouble attaching the file, I will try to upload shortly.

Hopefully its attached now.