Forum Discussion
Linking to the last item in a column in the previous sheet
I am creating a new sheet of a spreadsheet. I want the first cell in a column populated by the last cell of the previous sheet. The previous sheet isn't finished yet, so I will have to search for...
It is a dollar amount: =IF(A232>0,E231-C232+D232," "), Where column A is a date, E is the balance, C is the expenditure and D is a deposit. I tried your first example, but it filled in zero, where ='2023'!E231 produced a number.
- I tried again and it worked. Maybe I messed up in cutting and pasting. Thanks.