I have a model that takes a whole range of inputs to give you a final
amount you can borrow. I would like to use something like the
{=TABLE(,C3)} formula that would enter a number of data elements into
this model.


ie:

PAYE Income Rental Income Business Income Amount can
Borrow
$50k $10k -
(Plugs these three into model)
$100k - $50k
same again
etc....


I guess I can write a VB macro that does this line by line, but i'd
rather work smarter...

Thanks,

Tim