I have a requirement in which i want to read all pivot tables in my excel (like i have 20 pivot table sheets with each country name ) on the basis of a “main” sheet that contains country data .
i have attached a example sheet . (in real i have around 20 pivot tables in one excel with sheet name same as country name )
So , like one pivot table sheet for each country . I need to search amount present in main sheet with each country pivot table sheet ( if its present , i need to populate one column in main sheet)
How to do that ?
I have to looPivot_Read.xlsx (17.0 KB)