When I test formulas on a spreadsheet, it s a very manual process. I'm trying to figure out a way to automate this. Here's what I have so far.
I want to identify some input cells and output cells. Then record some known good values for the inputs and outputs and store them. [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/10/22/automated-formulas-testing/
Posted
Oct 22 2008, 07:24 PM
by
Daily Dose of Excel