SOLVED

Formulas

Visitor

Hello,

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.

1 Reply
best response confirmed by thegeorge26 (Visitor)
Solution
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.