Easy update of bank account values

[gunnberg]

I am pretty new to this so please forgive me if this is stupid.

I'm handling three bank accounts with a friend of mine. We both do daily deposits/withdrawals and at the moment we are using a shared excel worksheet where we update the numbers.

We now want this to be more advanced to keep even better track of how the accounts are developing.

Ideally each and one of us could login to this several times a day, enter the new value for i.e. Account_A. Then Account_B etc. At the end of the day we could produce a result sheet showing how much each of us had ended up adding to each account that day.

This way we would know what the total income/loss for the different days were. How much money each of us made/lost that day etc.

Is this even possible? I did a course in Microsoft Office a long, long time ago and my first thought was that an access database where we entered values into boxes or something would be nice, but I seem to have forgotten everything.

I'd really appriciate all input!

-Tony

 

[Gavona]

How about collecting your data using a sheet with columns for Person, Account, Date, Amount....

You could use a pivot table to produce a summary report at the end of each day, this could have separate columns for each Person and a total column.

The source data for your pivottable should be a named range specified in a way that it automatically expands as you add to your input sheet. faq68-1331

Post back when you hit a snag, and be specific as you can about what you are trying to achieve.

Regards,

Gavin

 

[SkipVought]

Hi,

Adding on to Gavin's excellent suggestion, using a PivotTable will make it possible to summarize by WEEK, MONTH, QUARTER, YEARS in a matter of mere seconds. It is a very powerful reporting tool IF you data is organized properly.

One additional suggestion: Use REAL dates.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[gunnberg]

I'm trying to play around with Dreamweaver. Think I can get a pretty nice result that way. Thanks for the suggestions anyway Might come in handy if I wanna give this solution a try.