Hi,

I would appreciate some help with the following problem I have.

I have 2 worksheets containing different data and column headings. I want to produce one Pivot Table that I can use to analyse the data from both worksheets.

I have tried using the consolidate multiple ranges method however this seems very limited and rather confusing. Is there any other way I can do this?

Regards

Emyn