using VBA to initiate multiple vlookup searches from a register, & export to new worksheet

[SenorMarks]

I am building a Context builder for a school I work in. This document uses codes to give an outline of the student using mainly vlookup and concatenate. I am looking to improve it by adding a "populate class print sheet" button in VBA which would take the names from the register, search their data and display it on the CONTEXT_Page before saving the data on a new worksheet and moving to the next name on the register. This way instead of searching each name individually a teacher could click the button and all of the students would have individual pages ready to print.

I would also like to be able to use a data val. drop down on the Statistics page to show the available codes and definitions from the codes page, so that in order to fill in the codes one needent changes sheets constantly.
If anyone could help I would be hugely grateful!

Thanks
Will

[vichopalacios]

Hi @ SenorMarks

As your consult has 2 different matters, let's try to go by parts.
I've prepared a code to solve the second:
.- validation lists has been created for every column, so you can choose the appropriate selection from the drop down list.
.- each time you click on a cell with validation list, it pops out on the right side the list of codes and the explanation.
.- you don't need to clean this list

If this part is OK, then we can proceed to the multi sheet code.

[SenorMarks]

Hi @vichopalacios That is exactly what I was looking for for the second part! Brilliant!

Thanks for this, after that, yes lets get down to the next bit! But amazing thank you so much!
muchas gracias!

[vichopalacios]

Hi will

Answering the question you posted ( before editing), I used a Change Selection Event.
as it is a worksheet event, you MUST place the code in a Worksheet Module, in your case, it is in Statistics sheet Module.

Now, in the standard module you created, I've changed some instructions and added some more, in order to get the entire list of student's pages ready to print.
Notice that in all the new sheets, there are no formulas, only values !
Here you have the book upgraded.

Now you can use both buttons: one sheet / all sheets

Vicho Palacios