I'm setting up a spreadsheet and wish to transfer data from the front page to
another page based on a Y or N desicion halfway across the front page. It's
a register system and all students' names & ID no's go on the front page
along with a list of activities. Each actibity will get a Y or N desicion
made depending on which activity the student did. The other pages behind the
froint page are for each activity.

I want the name to be transferred to the relevant page based on the Y or N
on the front page, however it won't transfer the text only the ID No.

Can anyone help?