On the left side of the "January" spreadsheet page, I have made a large section that totals all of the manually-entered data for each column (e.g. "Mortgage/Rent" and "Maintenance," which are programmed to automatically combine in the "Housing" total.). I have created the spreadsheet to automatically total the columns and rows to give me: 1) the combined total daily cost of all items, 2) the total monthly cost of each category (e.g. "Housing," "Utilities," "Insurance"), 3) the combined total monthly cost of all items, 4) the total yearly cost of each category, and 5) the combined total yearly cost of all items. However, I want to take this one step further, by allowing me to enter in my "Daily Expenses" and having all of the pages of the spreadsheet automatically update.
On the right side of the "January" spreadsheet page, I have created 31 smaller sections that represent my "Daily Expenses." I have included columns for the "Category" of the expense, the "Item" name, the "Cost." The "Category" section is a drop-down menu including all of the 48 categories (e.g. "Mortgage/Rent," "Maintenance," etc.) Above each of these 31 sections, I have written "1," "2," "3," etc. to indicate the date. So, what I would like to know is:
Is there any way to program the computer to read the "1" date and the "Mortgage/Rent" category and automatically transpose the "$1,000" I input by hand into the appropriate cell in the larger spreadsheet to the left? For example, if my "Daily Expenses" are as follows, how can I cause the computer to add all "Grocery" spending from the drop-down list and input the total in the correct cell on January 1st?
<tbody>
</tbody>
On the right side of the "January" spreadsheet page, I have created 31 smaller sections that represent my "Daily Expenses." I have included columns for the "Category" of the expense, the "Item" name, the "Cost." The "Category" section is a drop-down menu including all of the 48 categories (e.g. "Mortgage/Rent," "Maintenance," etc.) Above each of these 31 sections, I have written "1," "2," "3," etc. to indicate the date. So, what I would like to know is:
Is there any way to program the computer to read the "1" date and the "Mortgage/Rent" category and automatically transpose the "$1,000" I input by hand into the appropriate cell in the larger spreadsheet to the left? For example, if my "Daily Expenses" are as follows, how can I cause the computer to add all "Grocery" spending from the drop-down list and input the total in the correct cell on January 1st?
1
CATEGORY | ITEM | COST |
Groceries | Shaws | 6.41 |
Groceries | Hannaford | 15.93 |
Parking | parking meter | 2.50 |
Groceries | Wal-mart | 10.57 |
<tbody>
</tbody>