I have a shared excel workbook on SharePoint that is being used by a few users. This sheet tracks reach outs to counties across the United States. When a reach out turns into a lead it then gets copied to a separate worksheet to expand on from there. I attempted to write a script that would accomplish this but failed miserably. What I am trying to accomplish with this script is in the “US Counties” worksheet, column O will have the option to move that row to the “RSR” worksheet. The script would then copy data from that row and place it in a new row in the “RSR” worksheet. There is a little shift in the columns between sheets which I have mapped out in the table below. Any help or direction is greatly appreciated.