This page demonstrates how to create a one-way and a two way data table using VBA where the result of each scenario depends on a goal seek.  The data table does not realise that it is supposed to run a goal seek each time a new result is put into the table. Using VBA code … Continue reading Data Tables & Goal Seek