Clear Cell using Listbox
 

Hello, I have a spread sheet that I am using to track employees work
schedule. In it I have multiple range names (these are columns). "project
no","jp no", "account no", "part no". I can bring this info into a listbox
but what I would like to do is bring the "project no" into a list box and
then have a command button that would allow me to delete the selected project
along with the jp, account, & part from the worksheet. Then sort the ranges
based on "project no" so that there are no blank cells. appreciate any help