Moving row from one sheet to another
Here is my challenge. One of my team enters projects into Sheet1 using a form which results in new rows on Sheet1. Once projects from Sheet1 are approved the manager checks a checkbox which triggers the move of the specific rows to Sheet2. Sheet1 has columns that do not need to be copied to Sheet2. How do I prevent those additional columns to be copied?
If the complete row is copied by design, what is the best way to no display those additional columns? Hide them? Is there other options?
thanks for your help