Pivot table with criteria, is this feasible?

C

celua

I have a main workbook containing 1000 rows & 15 columns.

I wish to use pivot table to extract some columns based on criterias,
such as:

Region = WEST

CreationMonth = a cell located in an other workbook
(workbook_config!$a$4 which contains 05)

Ordereditem = "bikes" AND "wheels" AND "skate"

Is this feasible using pivottable? The top would be to allow end user
to manually

Thansk for your help,

Celua
 
Top