Cantonalives
Member
Hi all,
Subject probably covered many times however I am sadly unable to find a solution.
I have a pivot table with additional calculated fields on one sheet. A2:k12000 is where all the data is. In the 'I' column there is a piece of data that is the item I need the criteria on. Ideally I would like another sheet that contains the specific data(rows) based on 1 or 2 different criteria all within the 'I' column.
Due to part pivot table, I cannot use autofilter and also needs to be dynamic and I guess either formula or VB based.
Hope that makes sense?
Thanks in advance,
-CL.
Subject probably covered many times however I am sadly unable to find a solution.
I have a pivot table with additional calculated fields on one sheet. A2:k12000 is where all the data is. In the 'I' column there is a piece of data that is the item I need the criteria on. Ideally I would like another sheet that contains the specific data(rows) based on 1 or 2 different criteria all within the 'I' column.
Due to part pivot table, I cannot use autofilter and also needs to be dynamic and I guess either formula or VB based.
Hope that makes sense?
Thanks in advance,
-CL.
Last edited: