Using VBA macro to insert functions VS only using macro

In short, I would either:

Create a macro that runs every time a cell within a certain range is changed, and then writing out the result based on those cells.

-OR-

Create a macro to automatically insert functions that would do the same thing

Things to consider are that this would need to work on multiple tables of varying length without need to manually change anything, and that the results of individual sheets would need to be also displayed in summary on another page.

Which would be more desirable/more efficient/easier to implement?

The subject data entails testing procedures. Sheets contain testing criteria and a colu开发者_C百科mn containing PASS/FAIL results. I need to tabulate these. The start of the table and the end of the table are at different rows and are subject to changing.

Without seeing your actual problem I would definitely go for the first option. Having many formulas inserted into cells dynamically I think would be a pain.

Use the Worksheet_Change event and test whether the cell changed is one of your target range, then perform whichever action is required.