Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relate 2 tables in excel
I have a workbook with 2 tabs named "Outstanding Leases" and "Lease Returns".
Each table is a listing of transactions (Outstanding Leases has 3 columns: lease number, Part number and quantity)(Lease Returns has 3 columns: Lease number, Part number, and Serial number of part that was returned). I need to create a 3rd tab - a report that summerizes what was originally taken out on the lease and what was returned. I have 2 pivot reports that give me a cross tab query look, with the lease numbers in a row, and the the counts in columns by part number. My question is, how do I consolidate these pivot tables so that my client can look at one report and see the original quantities and what number have been returned. hope you have a suggestion - I've been racking my brain. Thanks cbra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how does vba relate to vb.net? | Excel Programming | |||
ADO; RELATE vs JOIN. | Excel Programming | |||
How can I relate more than 7 cells with IF(... | Excel Worksheet Functions | |||
Relate from one worksheet to another | Excel Worksheet Functions | |||
How can I relate three or more lists to one another? | Excel Worksheet Functions |