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
Bookmarks