I have set up a series of student worksheets to test a skill, for example binary addition. Steps:
1. I set up a series of random numbers which I've converted to 8 bit binary
2. I copied/pasted these so that there are 18 questions per page
3. I hid the columns and copied pasted the cells so that I have 36 pages on the worksheet
4. I print pages 1 to 36 and get 36 unique worksheets which a great I get a unique set every time I open the workbook to print some more too.
What is the best way to:
Add a student name, from a list, to each page in the worksheet. I could probably work out a messy solution but I wondered if there was a decent way to do this?
So I want the student names to appear in the yellow cells on attached image.
Thanks for any ideas...
1. I set up a series of random numbers which I've converted to 8 bit binary
2. I copied/pasted these so that there are 18 questions per page
3. I hid the columns and copied pasted the cells so that I have 36 pages on the worksheet
4. I print pages 1 to 36 and get 36 unique worksheets which a great I get a unique set every time I open the workbook to print some more too.
What is the best way to:
Add a student name, from a list, to each page in the worksheet. I could probably work out a messy solution but I wondered if there was a decent way to do this?
So I want the student names to appear in the yellow cells on attached image.
Thanks for any ideas...
Last edited: