Hi,

I am having issues trying to do a macro that will open a workbook and then create a pivot table based on values found in "data" sheet. Basically I have to do pivot for 90 workbooks, and that is why I am trying to do this macro. Each workbook has different amount of data so I am using this formula
Please Login or Register  to view this content.
this macro works good but I have to open manually each of the workbooks , paste this formula and then run the macro :S
Please Login or Register  to view this content.
A