I'm working with excel on an ICT project, and somewhere along the way, I've managed to make certain cells in Sheet 1 mimic cells in Sheet 2.
I'm using the first sheet to collect results from a questionnaire, and the second to count the number of people who answered the same. Whenever I add a formula to a cell in Sheet 2, the same cell in Sheet 1 changes from whatever I had before into that formula. I've asked a few other people, including my teacher, but no-one has ever encountered it before. All of this is a complete accident, how can I fix it?