VBA to filter out data within a pivot

**kenadams378** · 08-20-2013, 07:49 AM

Hi,

I need to write some code for a pivot table that says only show data that does not end in IM or CM or POOL, is there anyway to do this?

**alansidman** · 08-20-2013, 08:33 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**kenadams378** · 08-20-2013, 10:04 AM

Apologies, i've managed to complete this.

Thanks anyway!

VBA to filter out data within a pivot

LinkBack

Thread Tools

Rate This Thread

Display

VBA to filter out data within a pivot

Re: VBA to filter out data within a pivot

Re: VBA to filter out data within a pivot

Thread Information

Users Browsing this Thread

Similar Threads

Pivot table or filter to sort data?

Filter data set within pivot table

Data filter in Pivot table

[SOLVED] Can I set a filter on the source data for a pivot table

Pivot Table Data Filter Problem

Bookmarks

Bookmarks

Posting Permissions