G
Guest
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
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