Hi umesh,

It is difficult to decipher from your workbook what all the data relationships are, as various amounts appear to be replicated, but without formulae to demonstrate a dependence. On top of that, various amounts are introduced (eg mortgage, inheritance, retirement income) without any indication of how they relate to anything else.

That said, you shouldn't need any of the scenario worksheets. You should be able to build all of the logic into a small number of formulae on a single worksheet.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]