stapuff
05-24-2005, 10:20 AM
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
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