Thanks, ckane. I had the same question, and your answer worked!

"Rykar2" wrote:

Thank you so much ckane, it worked perfectly.
Thanks, I really appreciate it.

"ckane" wrote:

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.