Creating a Pivot table from two or more worksheet

[paradise]

Hi,

I have a two worksheet name PI and An.How can I create a Pivot with the help of a macro taking into the assumption the label are matched to the extent in one or the other based on availability of the data.Here,currently,I have highlighted which is required but I would require further so feasibility of code also would be preferred.

Thanx in advance.

 

[paradise]

Plz find enclosed in attachment excel file.

 

[Hui]

Paradise

It appears that you have cross-posted this file in a number of different forums

Please read the rules for using the Forums at:
http://chandoo.org/forum/threads/new-users-please-read.294/

Cross-posting wastes time and effort.

Please ensure that when you cross post you
1. Advise people of the fact that you are posting to several sites at the time
2. Advise all sites when a solution is found, so that people aren't wasting their time.

 

[paradise]

yeah.This has been posted at :http://www.vbaexpress.com/forum/sho...rom-two-or-more-worksheet&p=364112#post364112 and https://www.excelforum.com/excel-pr...-from-two-or-more-worksheets.html#post4688854 which I forget to mention the link.