Tacomanator
New Member
- Joined
- Oct 22, 2002
- Messages
- 15
Hi, I am trying to create a ledger in excel that looks like this:
Date | Type | Description | Amount | Balance
The first four fields should be entered manually, but I would like the balance to be calculated automatically using the sum of the previous balance and the amount entered. Follow?
1. So far from my messing around it seems like you have to have a function tied to a cell, therefore, how do I tell it that this entire column needs to do the same thing?
2. How do I reference cells such as, the cell directly above me and the cell directly to the left of me?
TIA
Date | Type | Description | Amount | Balance
The first four fields should be entered manually, but I would like the balance to be calculated automatically using the sum of the previous balance and the amount entered. Follow?
1. So far from my messing around it seems like you have to have a function tied to a cell, therefore, how do I tell it that this entire column needs to do the same thing?
2. How do I reference cells such as, the cell directly above me and the cell directly to the left of me?
TIA