Hi everyone
Could someone please explain to me step by step, I am a newbie to Excel at work.
This is what I need to know how to do.
I have a spreadsheet with the headings across the top:
Name Budget Jan. Feb. Mar. to Dec. Spent Balance
5 Rows with teachers names
What I need is if they start with a budget of $200.00, the balance column needs to say $200.00.
Then every month I put in what they spent and I need the balance column to change automatically.
I hope this is clear and not too confusing.
But I have no idea how to do this so that the balance and the spent column change automatically. So basically subtracting not adding.
Please someone help
Thanks so much in advance
Could someone please explain to me step by step, I am a newbie to Excel at work.
This is what I need to know how to do.
I have a spreadsheet with the headings across the top:
Name Budget Jan. Feb. Mar. to Dec. Spent Balance
5 Rows with teachers names
What I need is if they start with a budget of $200.00, the balance column needs to say $200.00.
Then every month I put in what they spent and I need the balance column to change automatically.
I hope this is clear and not too confusing.
But I have no idea how to do this so that the balance and the spent column change automatically. So basically subtracting not adding.
Please someone help
Thanks so much in advance