Howdy,

Assume that I have two identical ranges in different worksheets. Is it possible to create a union of these ranges and use it as the source of a pivottable?

I was trying to use the Union method but I think the fact that they are on different sheets is giving me an error so I am looking for a way around this.