I just posted this today and something seemed to have happened to it - got an email saying response submitted but when i go to view sais doesnt exist? so i have posted again
=IF(ISERROR( J2 (INDIRECT($M$13),B7)),"",( J2 (INDIRECT($M$13),B7)))
i have 3 scripts in modules.
on my output page i want to be able to select which script sets the page by typing either 1,2,3 in cell J2 and then the formula above will put in either
1=Concatsetdays
2=Concatsetdays2
3=Concatmth
if i type 1 then the first function will fill the page formula in J2 area of formula above
----------------------------------
=IF(ISERROR( J2 (INDIRECT($M$13),B7)),"",( J2 (INDIRECT($M$13),B7)))
i have 3 scripts in modules.
on my output page i want to be able to select which script sets the page by typing either 1,2,3 in cell J2 and then the formula above will put in either
1=Concatsetdays
2=Concatsetdays2
3=Concatmth
if i type 1 then the first function will fill the page formula in J2 area of formula above
----------------------------------