Balance Forward - Worksheet Set up

[Neon520]

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

 

[Brotha Lee]

Neon520,

If i understood correctly you have a sheet more or less like this

Account Month 1 Month 2 etc.
a
b
c
.....

A possible solution would be a sumif formula. By this way you are not
limited to where the account is stored and you can add more that one line for
an account. The only thing is to remember that balances can still be
unreconciled due to the fact there are "unknown" accounts in your
summarization sheet.

For example you could have account 'd' in a specific month. if this is not
in the summarization sheet it will not be summed and therefore you balance
would not reconcile.

Another option would be a consolidated pivottable report, however you data
in each sheet should be in structured manner like this.

Hope this will bring some new ideas,

Brotha lee