I am looking at the possibility of giving a user "select and delete options", but I am not sure of the best solution.

I have a sheet(1) column A that lists all warehouse names and column B is the associated part #'s for the warehouse.

Example

North YBAT12
North YBBU19
North ZZR321
South ACED15
South YBAT12

I am think along the lines of pivot table(ing) the part # column to give me a single list of part #'s. Then filling a listbox with the part #'s. The user can then select from the list of part #'s(multiple if needed)then hit a button to delete all occurrances of the part # and row information(via autofilter).

In the example above part # YBAT12 is located in the North and South warehouses. If a user selected YBAT12 to delete - that part # would vanish leaving the rest.

Any idea's would be greatly appreciated.

Thanks,

Kurt