Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables - Multiple Ranges
Is there a way to use pivot tables in Excel to accomplish the same result as an MS-Access process to "join" two tables on matching fields? For example, I have one range of data that contains employee time card information that includes a costing code for each time entry. I have a separate data range that contains, for each costing code, one or more records containing percentages that are used to allocate labor to specific business units. The desired result is a table or data range that contains all of the records from the time card range and all matching records from the allocation table. I've been able to build the result that I want using VBA code and vlookups but I'm looking for a better way. I've been researching Data consolidations and pivot tables with multiple ranges to see if this might work. So far, it seems that these processes in Excel are simply to combining data rather than simulating a join. Is there a way to do this with pivot tables or is code the only answer? Thanks in advance for any input!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables with Multiple ranges | Excel Discussion (Misc queries) | |||
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
Multiple Consolidation Ranges in pivot tables | Excel Worksheet Functions | |||
pivot tables: multiple consolidation ranges | Excel Programming | |||
Pivot Tables - Multiple Consolidation Ranges | Excel Programming |