Forum Discussion
Cell Use from one sheet to Another
Hello.
I have a multi-page workbook that requires using cells from one sheet on other sheets in the same workbook. I have one instance that in trying to work it out, has caused a second issue. When I try to add the cell from the one sheet to the next sheet using +=, then clicking on the sheet and cell to acquire it, when it posts is a 0. In trying to solve my issue and going to the sheet and cell in question, this is what I see. Highlighted cell. So, initially I was able to total that column. Now I can't because it no produceds a 0. It seems for some reason that cell does not show as =+'Wages'!G15, if I manually input that in the cell I need it in (on the other sheet) it still posts as 0. The source sheet for Wages is below this sheet. Can anyone help me get this worked out so I can use the required cell on the sheet i need to use it on?
1 Reply
HelloScottIGH2025,
If =Wages!G15 returns 0 then G15 on the Wages sheet is evaluating to 0. The issue is on the source sheet not the destination sheet. Confirm that G15 still contains a SUM formula and was not overwritten. Make sure the cells being totaled are numeric and not stored as text. Verify Calculation Options is set to Automatic. You can also test with =ISNUMBER(Wages!G15). If G15 evaluates correctly on the Wages sheet then =Wages!G15 will work on any other sheet.
