i have 3 worksheets in my WB; sheet1 is a bill summary for each months total for that expense catagory. sheet1 is set up like a pivot table with the expense catagories listed in range(A2:A3). Range (B2:M2) are the months in the year.
Sheet 2 and 3 are for the respected expense catagories for example sheet 2 is "Utilities" and sheet 3 is "Home Repair". Both sheet 2 and 3 are setup the same; Range(A1:A65536) is the date the expense was incured. Range(C1:C65536) is the Amount of the Expense (in currency format).
What i need is a macro that will Loop through the rows of each worksheet and total the amount of the expenses by month. Then copy the total monthly amount from that expense catagory, into the correct cell in sheet 1.
This is sheet 1 the summary worksheet...
this is sheet2 the expense catagory worksheet...
Sheet 2 and 3 are for the respected expense catagories for example sheet 2 is "Utilities" and sheet 3 is "Home Repair". Both sheet 2 and 3 are setup the same; Range(A1:A65536) is the date the expense was incured. Range(C1:C65536) is the Amount of the Expense (in currency format).
What i need is a macro that will Loop through the rows of each worksheet and total the amount of the expenses by month. Then copy the total monthly amount from that expense catagory, into the correct cell in sheet 1.
This is sheet 1 the summary worksheet...
| Expenses_06.xls | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 2 | Category | Jan | Feb | Mar | Apr | May | Jun | ||
| 3 | Utilities | $136.55 | $151.25 | $275.33 | $185.70 | $174.60 | $194.32 | ||
| 4 | Insurance | $1,009.00 | $654.00 | ||||||
| 5 | Auto-Repair | $568.30 | $568.30 | $736.29 | $568.30 | $568.30 | $568.30 | ||
| 6 | Auto-Gas | $128.50 | $103.00 | $102.08 | $148.14 | $211.37 | $84.29 | ||
| 7 | Grocery | $88.51 | $77.70 | $86.89 | $92.02 | $104.21 | $2.18 | ||
| 8 | Restaurant | $151.96 | $111.05 | $89.08 | $80.48 | $66.66 | $7.39 | ||
| 9 | Gifts&Cards | $204.32 | $21.15 | $17.36 | |||||
| 10 | Home | $584.24 | $549.24 | $3,441.77 | $589.12 | $663.97 | |||
| 11 | ATMWithdraw | $40.00 | $40.00 | $40.00 | $40.00 | ||||
| 12 | Donations | $290.00 | $290.00 | $290.00 | $340.00 | $890.00 | $340.00 | ||
| 13 | Investments | $250.00 | $250.00 | $250.00 | $361.11 | $361.11 | |||
| 14 | Clothes | $21.19 | $11.12 | ||||||
| 15 | Misc | $438.53 | $1,068.56 | $334.62 | $749.83 | $320.12 | $190.00 | ||
Bill Summary | |||||||||
this is sheet2 the expense catagory worksheet...
