Updating workbook formulas for additional variables

Originally Posted by nickpavlov

PMDJunqueira, that is very interesting. A few questions.
1. How did you do this? :-)
2. How can I expand the Summary worksheet to add more rows?
3. I need to work in more variables F2 & H2 on the Summary worksheet.
But this is pretty awesome, never worked with whatever you did!
Thank you,

All of this is because the new feature of Excel 365 to work with dynamic arrays.

1. You don't need to have and carry 1,000 of formulas any more, just one cell has it all!
2. There is no limit!!
3. I have already implemented that.

Look again the file, I am improving it in the first massage since I wasn't sure you where seeing it.