Sorry Augusto!! Not sure how that got in there!!

Anyway, check out the code that is in that link and post back if you have
additional questions.

Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ryguy7272" wrote:

Can it be done? Excel can handle almost anything you throw at it (I'm just
starting to realize some limits now...).
Anyway, check this out:
http://www.rondebruin.nl/copy4.htm

It is a batch processing macro. Basically, the text in red must be the code
that you want to operate on each file, each sheet, etc. Copy paste the code
in black, insert your specific code where the text is red, and you are in
business!

Post back if you have additional, specific, questions.

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Augusto_Madrid" wrote:

Hi everyone out there!

I have some 200 pivot tables and I need to do two things on them:

1) change one of the filtering variables above the tables
2) I need the new filter variable to be determined by a scroll menu that's
somewhere else in the same file, but a different sheet; e.g., if I choose
option "2" in the scroll menu, I need the tables to be filtered by variable
"2"

Can this be done at all?
Any help will be welcome, I'm stuck with macros here...
Thanks!


Augusto