Can I combine two worksheets into one pivot table?

[Todd]

I have two worksheets I want to build one pivot table from. There are 24
columns of data each. How do I do this? I have been trying multiple
consolidation ranges and its not working. I don't get the headers to choose
from when I try to create the table. I get Row, Column, value and page one
as options.

Thanks


Todd

 

[Frank Kabel]

Hi
do both sheets have the same, indetical layout?