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