Looping through in Pivot table Filter fields

[zsirsaman]

Hey guys,

I have a big problem and I hope that you can help me I want to print all of the filter fields (all of the offers) in a pivot table, and print the tables one below another to the same page. Iīm trying with the following code:

Please Login or Register  to view this content.

The code rolls down to the last item in the Filter field and prints only that table instead of all of them. Can you help me, please?

Thank you,

Best,

Dani

[humdingaling]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[humdingaling]

Please Login or Register  to view this content.

there is no printing (or extracting) being done here?
did you leave something out?

[zsirsaman]

Hey humdingaling!

Thank you for your quick reply. This is the first time Iīm using VBA to create Pivot tables. When I do it without the loop, the
Select Code
PvtTbl1.ManualUpdate = True
prints the table, simply like this:

[/CODE]

Please Login or Register  to view this content.

[/CODE]

Which command should I use to print the table?

Thank you guys,

Dani

[humdingaling]

you print tables the same way you print normal sheets in excel

heres a modified example of what you could do...printing to pdf in this case

Please Login or Register  to view this content.

^
this prints makes pi into a pdf into the \print\ subfolder of ThisWorkBook.Path
if you want the headers to repeat..you look that into pagesetup prior to running the code
you can shrink to fit on one page also ..this would require extra code

[zsirsaman]

Hey, thank you for your reply, I didnīt use the proper terminology. I donīt want them to be printed out, just to be displayed in the same sheet one below another. Right now it generates the pivot table and "rolls down" the filter field to the last entry (in alphabetical order). So instead of displaying all the offers, it shows only the last pivot table. If I donīt include the

Please Login or Register  to view this content.

part, then it displays the overall pivot table (for All the offers).

I hope now itīs clear what I would like to do,

thank you in advance,

Best,

Dani