There may not be any automatic way for the task. So, you got to do a bit of both (via Smart Markers and manual way). See the attached template file including Smart Markers for your needs. It will cover everything except the dynamic range, i.e., “C17:G21” for dynamic formulas. We think you may try using our shared formulas feature for it, see the document for your reference. Regarding insertion of rows when processing markers in the worksheet, we think you should use Cell.SetSharedFormula to set the formulas after using WorkbookDesigner.Process in code, so markers would be processed and data would be filled into the cells.
Hope, this helps a bit.
MatrixDemo1.zip (8.2 KB)