excel online: @prev or how to reference the previous cell

Question

Hello,

An excel file has the following formula

=@prev(A5)

This doesn't work when using Office Online.

Is there a way to reference the previous sheet? So that when a sheet is duplicated, the information is accumulated across from one sheet to the next, ad infinitum. So we can end up with 52 sheets and the total from the previous sheet will be carried forward to the next sheet.

Thank you,
Andy

Answer 1

You could have the previous sheet's name in a cell - say, cell A2 - and use a formula like

=INDIRECT("'" & A2 & "'!A5")

But you would need to enter the previous sheet's name into cell A2 for every new copy of the sheet.

A much, much better approach is to use just 1 sheet, with additional columns of key values (I assume week number is important) to which you can apply filters to replicate the view that you want with each of the 52 sheets. Then you will have all your data in one table - from which you can create new tables using Power Query or Pivot Tables.