Google Script App - Copy & Paste Loop

[MS93CP]

I have a bunch of data in a Google Sheet and I’m trying to create a simple script that’ll loop and copy it over into the correct place in a second Google Sheet.

DM SAMPLE SHEET (SOURCE)
SM SAMPLE SHEET (DESTINATION)

Rules for copy and paste:

1. Loop through each row in the source sheet.
   1. If the row is for a pick-up job (determined by time present in column D), then copy time from column L (Completed time) to SM's column Q (actual pick-up time), determining the row by matching the order number.
   2. If the row is for a delivery job (determined by time present in column E), then copy time from column L (Completed time) to SM's column S (actual delivery time), determining the row by matching the order number.

The script needs to be able to be manually run periodically to update the SM SAMPLE SHEET with all the times from the DM SAMPLE SHEET.



Removed link to DM sheet

 

[Norie]

Can't really help with documents that can only be viewed.

 

[MS93CP]

Can't really help with documents that can only be viewed.

Apologies! Wasn't sure what best-practice was; whether you would make a copy of the document or would want edit access! I've enabled edit access.

 

[Fluff]

I have removed the link for the DM sheet as it looks to have the phone numbers for your drivers.
If they are real phone numbers I would suggest that you remove them before supplying a new link

 

[MS93CP]

I have removed the link for the DM sheet as it looks to have the phone numbers for your drivers.
If they are real phone numbers I would suggest that you remove them before supplying a new link

Thank you. I have removed them from the sheet. Here is the new link.

 

[Norie]

Looks like it will need to be a copy and paste job - when I try adding code to your sheets I'm getting all sort of permission, security stuff.

 

[MS93CP]

Looks like it will need to be a copy and paste job - when I try adding code to your sheets I'm getting all sort of permission, security stuff.

When I sign in using a different Gmail account it lets me go into the sheet and select Tools > Script Editor and add scripts and press save. What errors are you receiving?