Managing workbooks excel referencing

[mele_4473]

Hi I am trying references cells across worksheets.  When I do it says zero instead of moving the cell over to the next worksheet

[#2]

@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.

[#3]

@Riny_van_Eekelen thank you so much! I appreciate your help! I see now what I did.