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
|