Forum Discussion
cc trampel
Apr 01, 2017Copper Contributor
#ref! when trying to copy paste
I'm trying to copy text from one sheet to another and have another sheet display both sheets. But I want the copy/pasted info to show up in that sheet. When I do that it displays a #ref! error in that cell that the info was supposed to go in and also the cell that I copied from (in the other 2 sheets).
6 Replies
Sort By
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.
- cc trampelCopper Contributor
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.
- cc trampelCopper Contributor
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.