Forum Discussion
Managing workbooks excel referencing
Hi I am trying references cells across worksheets. When I do it says zero instead of moving the cell over to the next worksheet
mele_4473 What exactly are trying to do? Referencing a cell on another worksheet doesn't move it. It merely displays/uses the value of the referenced cell. For example, if Sheet1, cell A1 contains the number 10, you could enter a formula anywhere on Sheet2 like =Sheet1!A1 to display the number 10 in that cell.
Riny_van_Eekelen thank you so much! I appreciate your help! I see now what I did.