• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Loop to fill filter field

T

tomas

Active Member
Hi,

In K column there is pivot table created manually which I want to create in VBA. I started macro end partial result in column C.

WHat is the problem:

I need in C column containig Date values to go into filter fielt and activate only this values where Brand B was active.

E.g Brand B was not active 1.1 and 2.1 which loop should recognize and unclick this dates in filter

thanks
 

Attachments

  • chandoo 2.xlsx
    32.7 KB · Views: 7
Hi ,

If you say you have started a macro , can you either post the macro code , or re-upload your workbook with the macro in it ?

Narayan
 
Hi

I thought it was there.

Anyways I made a change since the size of data I will have to pull data from sql as diplayed in column H with is unique list of dates where Brand was active.

So it's little simpler just want to make visible pivot items which match with dates in column D.

PS. I tried code today for each pitem in pfield.pivotables but there was some mismatch but forgot to save the code
 

Attachments

  • chandoo 2.xlsm
    43.3 KB · Views: 2
You must log in or register to reply here.
Back
Top