Forum Discussion
Marc von Osinski
Jul 23, 2018Copper Contributor
Cell won't reference cell in other worksheet?
Sometimes I copy a worksheet from one workbook to another workbook. How do I do that without making the copy reference the original workbook? I want the worksheet to reference the other worksheet i...
Marc von Osinski
Jul 27, 2018Copper Contributor
Thanks! So the other problem, that may not be connected to that is when I have a cell that won't reference another Worksheet in the same Workbook?
Ex:
I'll type "=" then click over to the other page and click on the cell I want to be referenced. Usually, that shows the value of the cell on the other sheet but in just these few cells it just shows "=Schedule!B1" which is the name of the cell I want referenced instead of the value? It's not like that everywhere on this Worksheet but just these few cells I need that information in. I've selected those cells and hit "Delete" to try and clear the cell but it doesn't seem to work? Suggestions?
Thank you.
JKPieterse
Jul 28, 2018Silver Contributor
Change the format of those cells to something other than text. Then F2 enter the formula.
- Marc von OsinskiJul 28, 2018Copper Contributor
THANKS AGAIN!!!!!!! WOW, YOU ROCK!