Has anybody seen any sample macros that do basically what a data table
does to avoid the requirement of needing the input sensitivity
variable(s) being on the same sheet as the data table?

Am thinking it should be fairly straightforward to have a macro
iterate down a column of scenario values, change the input variable,
copy result until end of column. But alas my VB skills, for now, are
sub-novice.

Thoughts?