Generate a Pick List

[JERRY89]

Dear All,

Good Day,

May I know is there a way for to Generate a Pick List for user to search a Spare Part based on Spare Part Name & Group where user can choose to sort based on Spare Part Only or both so after they pick they can add in directly to the cell C2 onward. Usually my Spare Part have more than 1 Thousand so i need this to ease user searching process in adding to the list.

[HansV]

That is a tall order! It'll take a while.

[JERRY89]

Hi Hans,

Is ok, take your time....

[HansV]

See the attached version.

Double-click a cell in B2:D11 to display a userform with a list of parts, groups and prices.
You can sort the list by clicking the buttons above the list.
You can filter the list by entering part of a name in the box and clicking Search.
To enter data in the sheet, double-click an item in the list, or select an item and click OK.

Spare Part List.xlsm

[JERRY89]

Hi Hans,

It is really awesome,too perfect too speed up my task.Thanks alot