I am trying to move the information from one sheet1 to sheet2 based on a simple "Yes or No' trigger. if yes is in the first column of sheet1 then the information that is in the subsequent cells to the right would automatically move to the sheet2 in the same cells. If No then the information would stay on the current sheet. I would also like column 1 of sheet1 to not move to sheet2.
