Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I recently took a part-time job as bookkeeper for an organization where I
need to be able to print a report on demand of current finances. I have a workbook with 3 sheets. The first one is the General Ledger Report, 2nd, receipts, and 3rd, lists the disbursements. My general ledger is: Begin. Bal. plus Receipts minus Disburs, plus or minus transfers =ending balance. The Ledger is listed by categories while the other two sheets are entered by the date each action occurs. Although I have used Excel for some time, I have only dealt with the simpler formulas and have never linked sheets together in a workbook. Is it possible to link the receipts and disbursements to the General Ledger so that every time I make an entry, it will reflect in my General Ledger report? Any info will be appreciated. Using Excel 2003 SP1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of worksheets | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |