ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining 2 Tables Dynamically into third new Table (https://www.excelbanter.com/excel-discussion-misc-queries/248480-combining-2-tables-dynamically-into-third-new-table.html)

Carl S.

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









Herbert Seidenberg

Combining 2 Tables Dynamically into third new Table
 
Excel 2007 PivotTable
Consolidate Tables
http://www.mediafire.com/file/z2zmnwdkwkm/11_15_09.xlsm


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com