Take a look at this link
http://www.contextures.com/xlPivot08.html
I was unable to get the data to work correctly. I was told that it probably
will not work well.
"Rykar2" wrote:
Hi all,
I need to create a pivot table to total all the date I have in 2 different
sheets in a workbook (I had to break it down because all the data adds to
more than 100K lines).
Is there a way to do this?
Thanks in advance.