I have two separate worksheets and each worksheet has a pivot table. Is there a way to combine the two pivot tables. Basically the area that counts the data need to be combined.
I can do the obvious which is of course copy each for values only and merge them that way but thought there was a way to merge two pivot tables.
I can do the obvious which is of course copy each for values only and merge them that way but thought there was a way to merge two pivot tables.