VBA filter columns of pivot table.

Hello friends! Hope 2017 is good to you all!

I have the following code; it filters the column and shows the results of Sep-16. I am also trying to display the column “Oct-16”.

But, Oct-16 is not appearing. Please help and thanks a lot in advance!

Please Login or Register  to view this content.

Use / not \ for code tags like: [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] or just select your code and click the # icon at the top of your post window.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

thanks! the attachment is placed here. ok in the column field I see many choices, I only want the VB code to Display Sep-16 & Oct-16 as two columns (side-by-side).

Try this. Put the months to filter in Variables Value1 & Value2

Please Login or Register  to view this content.

If you want to add another filter, add another variable, say for e.g. Value3 and add it between the FOR Each Loop

Please Login or Register  to view this content.