Good call Jacob! I was just going to paste the very same link in here. That
should do it. As an alternative, you may consider manually copying your data
into one consolidated range, make sure the Field names (Headers, or whatever
you want to call them) at the top are the same (data must be in the
appropriate columns).

You can take a look at this if you have time:
http://www.rondebruin.nl/copy2.htm

That will merge everything in your workbook into a Summary Sheet, and then
you can build your Pivot Table off of that (I do that all the time). Again,
make sure the Field names are lined up appropriately. Pivot Tables are great
for summarizing sets of data, but when the data in in Pivot Table format, you
ability to control it is somewhat limited (not so limited, but certainly more
limited than in a Range outside of the Pivot Table).


HTH,
Ryan--

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


"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.