You would need to name each table in each of those sheets (only the data portions). The names would need to be a combination of exactly what is in B2 and C3 (but without any spaces)...e.g:OnePathOneAnswerInvestmentPortfolioConservative
Also, it would be recommended to not use Merged cells. Instead just make single columns and widen as necessary to give the correct appearance.
Then you could simply use formula:
Code:
=IF(ISERR(INDEX(INDIRECT(SUBSTITUTE($B$2&$C$3," ","")),ROWS($A$1:$A1),COLUMNS($A$1:A$1))),"",INDEX(INDIRECT(SUBSTITUTE($B$2&$C$3," ","")),ROWS($A$1:$A1),COLUMNS($A$1:A$1)))
copied down and across the 3 columns.
If you have XL2007 or later:
Code:
=IFERROR(INDEX(INDIRECT(SUBSTITUTE($B$2&$C$3," ","")),ROWS($A$1:$A1),COLUMNS($A$1:A$1)),"")
Bookmarks