So I'm having a hard time finding an answer to this question I have a bout Excel. I have an excel file with multiple work sheets. Each sheet needs to be separate from the others, but information randomly copies from one sheet to another sheet, and at times even overtakes existing information on this sheet. The thing that happens the most is that entries from one sheet will show up several cells below any entries on other sheets.
I've attached screenshots of the issue. The first picture, labeled "screenshot 1", is the worksheet where i typed in the information, and the second sheet, labeled "screenshot 2", is another sheet in the same document, and the info from the other sheet appeared there. I also noticed that they are the same line number from the original sheet. I've also noticed in certain instances that if I delete the info off of the sheets that it isn't supposed to be on, that it deletes in the original location as well.
I'm guessing that this is some sort of formatting issue, but I'm totally lost.
PLEASE HELP!
Bookmarks