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
|