Hi @ all,
I'm new here and this is my fist time to describe a problem in excel so please excuse if i get something wrong...
So this is my problem:
I need a marco that changes the filter of a pivot table (actually that are three tables).
Not all numbers are in every table
then the macro should copy the results as values in another workbook (one after the other)
Example:
Filter=1111
Pivottable1= 20 Lines (excluding sum (last line))
Pivottable 2= "1111" does not exist
Pivottable 3 = 4 Lines (excluding sum (last line))
Copy this as values in new Workbook starting line 3, so that lines 3-20 show results from Table 1 and lines 23-26 show results from table 2.
The problem is, that i will have like 40 different filter values and so the number of lines is always different and its possible that the filter value exists in every pivottable...
It would be awesome if someone would have an idea...
thanks in advance..
I'm new here and this is my fist time to describe a problem in excel so please excuse if i get something wrong...
So this is my problem:
I need a marco that changes the filter of a pivot table (actually that are three tables).
Not all numbers are in every table
then the macro should copy the results as values in another workbook (one after the other)
Example:
Filter=1111
Pivottable1= 20 Lines (excluding sum (last line))
Pivottable 2= "1111" does not exist
Pivottable 3 = 4 Lines (excluding sum (last line))
Copy this as values in new Workbook starting line 3, so that lines 3-20 show results from Table 1 and lines 23-26 show results from table 2.
The problem is, that i will have like 40 different filter values and so the number of lines is always different and its possible that the filter value exists in every pivottable...
It would be awesome if someone would have an idea...
thanks in advance..