babyhuey20042003
Thread Starter
- Joined
- Sep 22, 2008
- Messages
- 2
I am, at best, an intermediate user of Excel - I do not use macros and am not a great mathematician - That said, here is my problem.
I am the treasurer for a Senior's Society, responsible for budgets and reporting. The Bookkeeper uses Simply Accounting for monthly transactions and, at month end, prints an Income Statement of appx. 115 lines. I take this statement and, by combining lines (using $A$1) and/or ($A$1)+($A$2),reduce this statement to a 50 line (+/-) Statement for incorporation into a monthly comparison budget (budget vs actual). When I use the formula (Cell A1 in the budget = JULY08 SIMPLY cells $C$5+$C$6+$C$7) the formula bar reports, when budget Cell A1 is highlighted,='JULY08 SIMPLY'!$C$5+'JULY08 SIMPLY'!$C$6+'JULY08 SIMPLY'!$C$7. I wish to use, each month, the same Cell Addresses but from the new month without having to go through and reformulate using the new month (ie ='AUG08 SIMPLY'!$C$5+'AUG08 SIMPLY'!$C$6+'AUG08 SIMPLY'!$C$7). Can anyone help.My file copies exceed the size limit - if needed, will reduce size and forward.
Many thanks - DAVE
I am the treasurer for a Senior's Society, responsible for budgets and reporting. The Bookkeeper uses Simply Accounting for monthly transactions and, at month end, prints an Income Statement of appx. 115 lines. I take this statement and, by combining lines (using $A$1) and/or ($A$1)+($A$2),reduce this statement to a 50 line (+/-) Statement for incorporation into a monthly comparison budget (budget vs actual). When I use the formula (Cell A1 in the budget = JULY08 SIMPLY cells $C$5+$C$6+$C$7) the formula bar reports, when budget Cell A1 is highlighted,='JULY08 SIMPLY'!$C$5+'JULY08 SIMPLY'!$C$6+'JULY08 SIMPLY'!$C$7. I wish to use, each month, the same Cell Addresses but from the new month without having to go through and reformulate using the new month (ie ='AUG08 SIMPLY'!$C$5+'AUG08 SIMPLY'!$C$6+'AUG08 SIMPLY'!$C$7). Can anyone help.My file copies exceed the size limit - if needed, will reduce size and forward.
Many thanks - DAVE