Hi Everyone,

I would like to set up a worksheet with multiple account for 12 consecutive
months that will bring the balance forward each month. I know how to set
this up if each account stay on the SAME line/column each month across by
linking them together (=Sheet1!A2 so on and so forth)

The problem occur when in some occasion there are more than one line appear
for a particular account and account can be terminated or added. In short,
they are not stable, they are fluctuated.

What is the best/most practical way to set up a workbook that I can
accomplish this?

Thank you for any suggestion.

Neon520