Combining 2 Tables Dynamically into third new Table

C

Carl S.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't solve simple? problem. Can some genius out there help! 2
Fiscal year 2
Date Series into new Table 1
Help with Table 6
enter data into a table that is based on 2 other tables 1
Summing exported data from 2 tables into 1 table 2
Outlook connector crashes outlook 0
Outlook crashes with Outlook connector 2002 0

Top