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!!!
|
Similar Threads
