Ok, well it will take a little creativity on your part, but you can
definitely do this. Make sure you have Field names (you HAVE TO have names
at the top of each column - make them up to match the criteria under them).
Put the table with 18 columns in a sheet, then place the table with 10
columns under it, with 'Tech Name' in the same column, the other 9 columns
would have to be pushed off to the right, so the first one starts under
Column19 (one past the 18 from the Table above). Both tables should line up
under the Tech Name criteria, or this identifier, or whatever you want to
call it. Then, build the Pivot Table. I'm not doing it right now, but I
would surmise that that would work fine for you.

This is really turning into an Access question. Can you use Access? That
would make this project MUCH easier!!

HTH,
Ryan---





--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gringarlow" wrote:

The tables do not have the same formats or ranges. One table has 10 columns,
the other 18 columns. Data is very different in both. The only common column
is the Tech Name.

"Jacob Skaria" wrote:

Hope the data format of both ranges are same. Refer
http://www.contextures.com/xlPivot08.html

If this post helps click Yes
--------------
Jacob Skaria

"Gringarlow" wrote:

I have 2 tables of data, one shows %'s of errors for individual techs, the
other shows details of the techs work that caused the errors. I tried to
build a pivot table using multiple ranges of both table, but can't get the
results I need. I want to show the Tech Name ( Which is a field in both
tables) and the %'s . Then what I was asked to provide was the ability to
click on the name and get the details on a new sheet. I can't figure that
part out.