How to search for the value in a list and cut and paste it to the end of another list on a different sheet?
I have 3 worksheets. On “sheet1” is a form that lists a value in cell “A1”. I need search for that value in a list in column “A” on sheet2. If found, I need to delete that cell and paste the value at the bottom of the list in column “A” on sheet3.