![]() |
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!!! |
Combining 2 Tables Dynamically into third new Table
|
All times are GMT +1. The time now is 04:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com