Hello

(warning: excel noob)




I have a series of tables of identical size down a single worksheet, each representing a variable.

In an empty table towards the bottom, I want to solve for one of the above tables as if it was an unknown. I want select the unknown via a data validation list or option button. In other words, when the selection is changed, I'd like to fill down and across an equation.

I would like to do this using table references, since these tables will change size.

In what way can I fill an equation down and across using table references? I can post an example workbook if necessary, but it would require taking a lot of data out of it first.

Thanks,
Mike