Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all,
First of all, I love this site and use it alot. I am hoping someone can help me out. I have a list of 360 people in a column who attend camp. They were given a stipend to use daily for candy, etc. Each item has specific dollar amounts and I want to use this spreadsheet on a daily basis to track money left on a campers account so we know how much they have left and notify them that they need to refill their money account. I hope this makes sense. Joe $100 Lisa $75 Mary $200 Kristy $150 (in any column: chips, m&m, pop, juice, etc) (in any column: $$ amount of each item cost) I am hoping there is a way to create a shortcut so that I can simply click the item that the camper bought (juice, candy) and then have it subtract it quickly and show it in a column. Any help is soooo much appreciated, thank you kindly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want a series of letters to equal a dollar amount? | Excel Discussion (Misc queries) | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Help with keeping track of payments | Excel Discussion (Misc queries) | |||
How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
how do I set up a total amount automatically in excel | Excel Worksheet Functions |