I am a novice excel user. I need a macro that I will assign to a command button. When the word "CLOSED" appears in column M, I would like the command button to copy the information from columns B-M into a new worksheet titled "discharges". I would like to clear contents from the original...