I have someone who is updating the formula tab by tab and cell by cell. and is asking if there is a way she can update the whole spreadsheet in one step? They are using windows 10. I can even try and get a screenshot as well.
If you are on Microsoft-365 then you may use dynamic spill array formulas. Better attach a sample workbook with few sample data as well as desired output.
