| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
aging workbook
I need to create an a/r aging workbook using the following information: Col A Acct # Col B Name Col C Date Col D Beg Bal Col E Charges Col F Payments Col G New Bal I've tried pivot tables, queries, but my problem is that except for Beg Bal, the Charges, Payments, and New Bal change each month. I've tried setting up a workbook with Beg Bal @ the 1st of Jan., but I need something that will help me apply new charges and payments, equaling a new balance, then calculate aging in 30, 60, 90, etc. buckets. Hope I'm stating this clearly enough. Any help will be greatly appreciated :) -- mlouie ------------------------------------------------------------------------ mlouie's Profile: http://www.excelforum.com/member.php...o&userid=34137 View this thread: http://www.excelforum.com/showthread...hreadid=539072 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Threaded Mode
