Forum Discussion
#ref! when trying to copy paste
Hi cc,
Sorry, but i didn't catch what exactly you would like to do. Just take into account when you copy/paste you paste everything - not only cell value, but references, formatting, etc. To paste only the value use Paste special from the paste menu.
ok, it's hard to explain.. I would like to be able to move rows of names from one sheet to different sheets. But I would like a main sheet where all the names are alphabetical and where I can sort different columns in that main sheet. So, when I take a name that is in one cell from sheet A and paste in sheet B.
Betts Mookie 2B BOS 9 4 0 16 0 bears #REF! #REF! #### #REF! #REF! #REF! #REF! #REF! 0 brainiacs so in above example, this is what would be the main sheet. There are no formulas, just reading cells from other sheets within the workbook. So where Betts is now he should be where I'm getting the #ref! error. and that row should be blank.
basically it's a fantasy baseball league. Each sheet contains all the players for one team, there are 12 sheets. And I also have a main sheet that contains all of the players. It's all good unless there is a trade and I need to move a player from one sheet to another. Then the Main sheet gets this Ref error when I do move them.
Hope that makes sense.
Yes, #REF! appears if you paste over the cell on which you have the reference. As i understood you need to move the row (which is actually the record about the player) from one sheet to another.
To avoid paste over i'd suggest
1) select entire row in first sheet
2) right click menu - Cut
3) select any row in the second sheet
4) right click menu - Insert Cut Cells
5) return to first sheet and delete empty row
