aaghd
04-22-2008, 09:18 AM
I have a checkbook registry type of spreadsheet, it includes a running balance column. I need Excel to look in that range (RunningBalance) and find the last entry posted; after it finds it I need it to put it in another cell, i.e., Cell H2 would equal the last value in the range RunningBalance. then I could take H2 on all the sheets and total them on the Summary Sheet.
My goal is to have a different registry sheet for each pot of money and on a summary sheet sum the current balance on each sheet. Of course the problem is that as you enter transactions on each sheet the cell with the current balance moves as well.
Excel has to have the capability of doing this! I just don't know how.
Thanks in advance for your help.
aaghd
My goal is to have a different registry sheet for each pot of money and on a summary sheet sum the current balance on each sheet. Of course the problem is that as you enter transactions on each sheet the cell with the current balance moves as well.
Excel has to have the capability of doing this! I just don't know how.
Thanks in advance for your help.
aaghd