Hi,
Macros can do just about anything you want.
If you do not get a reasonable respose from this group then
send me a sample sheet of your work and I will try to
write a macro for it.

Regards Mark


HTTP://au.geocities.com/excelmarksway

-----Original Message-----
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?
.