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
Bookmarks