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