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...
I'd like to play with that and understand it, even though Hans got me a solution that I like. Could you walk me through where to place that command, and what it will show? Since it doesn't show the 2023 page, I infer that this formula goes on that page. '2023'E:1 contains the word "balance", so I'm starting on row 2, if that is useful.
I have attached a file based upon John's Pivot Table sheet that shows the data carried/brought forward from 2021 to 2022. The formulas are all dynamic array formulas using defined names or structured references and are very different from traditional spreadsheet development.