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.