I need a user form in Excel which allows you to search and selection of items Pivot Field in Pivot Table.
I have Pivot TableS with pivot fields such as “book” or “customer” or “Invoice”. Each of these pivot field may have 20000 Pivot Item.
The User Form must:
deploy a combination of keys
allow searching in any of these fields (the user selects that pivot field will search)
the search must allow the use of wildcards (eg “book” contains “owne * manu).
display a list of all the pivot item containing “owne * manu”
Allow selection of 1 or more of the pivot item shown in the list
confirm selection
return to the Pivot Table by selecting the items marked on the user form and hiding the rest
Must work quickly, keep in mind that the pivot item may be several thousand.
It must work in Excel 2003 or 2007 .
The user must form a mark that achieves this selection to every pivot table of the active sheet or sheets of the active workbook.
The userform will be stored in a book in the XLStart folder.
I use Excel 2003 or 2007 with a Spanish version . I have to be able to adjust it to 2 or 3 different cases (minor changes to open source).
I will deliver a dynamic table in 2003 and another version in 2007 for testing verion.
Scrow payment