I am using Excel 2007. I have a spreadsheet that is shared by a couple of us in the office. The last person that accessed it did something so that when I add data to a column, it appears on all the other pages in that column.
Basically it is a sheet for each of my doctors, and I keep track of how many days they spent in the clinic, at nursing homes, days off etc. So when I enter the data on Dr B's sheet, it copies to all the other Doctor's sheets also.
How do I fix it so it will only put the data on the correct sheet, and not on every sheet?