Running Balances

I have been asked to create a single workbook with several worksheets. One
of these sheets has to ne a control that keeps track of the running balances.
The remaining sheets are all the same. They need to record in / out figures
and show a running balance at the bottom - this I am able to do. What I am
having difficulty with is the control sheet. This needs to record individual
transactions from within the other sheets. How can I get it to record the
dates and the incoming and outgoings of all the other sheets so these can be
reconciled with the bank statements. I am able to get the control sheet to
keep track of the running balances by using =A!H4+B!H4, but how can I get it
to record the individula dates of the transaction of these sheets.
Hope I have made myself clear.
Thank you all. S

Hi
Can you be a little clearer please. S

"mrice" wrote:

>
> If I understood your question correctly, you may well need to use some
> event driven VBA. If you put some code onto the ThisWorkbook tab in the
> VAB editor linked to the Workbook_SheetChange event, you could put
> timestamped transactions on your control sheet by use of the Now()
> function.
>
>
> --
> mrice
>
> Research Scientist with many years of spreadsheet development experience
> ------------------------------------------------------------------------
> mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
> View this thread: http://www.excelforum.com/showthread...hreadid=559439
>
>