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