If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Running Balances
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 |
#3
|
|||
|
|||
Running Balances
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 |
#4
|
|||
|
|||
Running Balances
Sal My apologies - its difficult to know how to pitch responses. I'm suggesting that what you need is a macro which is triggered when you add a date to one of your individual sheets. This macro will take the current time from the system clock and place a value on the control sheet. The function to do this is called Now(). You will find details in the help file. To trigger the macro, the code needs to be placed on the ThisWorkbook tab of the VBA editor (Shift F11) and given the name Workbook_SheetChange so that it runs every time a cell's contents are changed. Without knowing the detail of the sheet, its not possible to write the code here. I hope that this helps. -- 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Running Sum in VBA | Mercedes | Setting Up & Running Reports | 5 | November 2nd, 2005 10:01 PM |
Running Total in Access 2002 | [email protected] | General Discussion | 2 | October 27th, 2005 02:11 AM |
Pivot table (Running Averages) | cs02000 | Worksheet Functions | 0 | March 6th, 2005 10:11 PM |
Running Averages | GOL | General Discussion | 2 | February 23rd, 2005 10:48 PM |
Reporting the last record, with running sum | snake | New Users | 0 | February 9th, 2005 07:45 PM |