Office Script to Copy Rows From One Worksheet To Another.

[SlightlyClueless]

Hello All!

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.

RSR Worksheet Coulmns	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z:AL
Column Letter From US Counties Worksheet	A	B								G	H	L	M	N								P	Q	R	S	T:AE

 

[SlightlyClueless]

Link to sample sheet - Sample Tracker (6) (2).xlsx

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Office Script to Copy Rows From One Worksheet To Another
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.