Copy whole row based on criteria

[Cantonalives]

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.

 

[chirayu]

please attach sample file. please state criteria.

 

[Cantonalives]

Hi,
Please see attached with is just an anonymised version without Pvt.

Criteria on output tab.

Thanks..


-CL

 

[chirayu]

attached

 

[Cantonalives]

Excellent - thank you.