Can I combine two worksheets into one pivot table?
 

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

Hi
do both sheets have the same, indetical layout?

--
Regards
Frank Kabel
Frankfurt, Germany

Todd wrote:
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