If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining 2 Tables Dynamically into third new Table
Below is data from two tables. How to I combine them dynamically, while at
the same time selecting records that belong to customer CARL? I am familiar with VLOOKUP, etc, I just don't know how to combine them into a new third table that can be sorted by date yet contains dynamic data. Table Deposits (First Table) Customer Date Deposit Carl 1/25/2008 $150,000.00 Carl 2/28/2009 $50,000.00 Joe 3/5/2008 Table Withdrawls (2nd Table) Customer Date Withdrawl Carl 1/28/2008 (6000) Joe 3/1/2008 (3000) Carl 4/12/2008 (4000) Joe 5/5/2008 (7000) Table cash flow (third table combined from two above dynamically). The desired result is listed below...how do I get this result? Customer Date Depost Withdrawl Running total Carl 1/25/2008 $150,000.00 $150,000 Carl 1/28/2008 (6000) $144,000 Carl 2/28/2009 $50,000.00 $194,000 Carl 4/12/2008 (4000) $190,000 Thanks for any help offered!!! |
#2
|
|||
|
|||
Combining 2 Tables Dynamically into third new Table
|
Thread Tools | |
Display Modes | |
|
|