Excel Macro: Run a Calculation Sheet Per Row of Input Sheet
In this video we demonstrate a simple Excel Macro in VBA that can be used to run complex, whole sheet calculations per line of input in a separate sheet. After each run, the results are copied back to the specified columns in the input sheet. This process is useful for performing multi-step engineering calculations that require traceability for QAQC purposes.