Excel 2010

[staningrimsby]

Hi Guys,

 

I am after a bit of advice please, our SBM has created an excel spreadsheet that covers the next 12 months,

each month is represented on a single worksheet listing the outgoings of the budget finaly leaving the balance.

 

The next worksheet starts with the balance being carried forward from the last, she would like a way of this being automated

so if she amends one sheet it ammends the other and so on.

 

Is there a formula or has anybody any idea of how you would do this ???

 

Regards

Stan.

[staningrimsby]

Worked it out thanks guys.