View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Sum if functions not copying text

Can you post the formula(s) you are using at present?

Pete

On Jul 3, 12:17*pm, John wrote:
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?