Pivot Table with data in different sheets

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Steven]

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