I'm looking for a way to copy and transposing paste between Sheets : in sheet 1 I have the small jobs assigned to some people with a summary line that tells me if they are free (they can do up to 3 jobs M and P)
In sheet "Peter", "John" etc. I have shared planner of that people, where each one marks in his sheet other own commitments divided between morning and afternoon for each day. There are also two spaces M and P where everyone manually marks the existence of commitments with me.
I would like to copy the data in sheet1 personal row and paste in the M and P columns in the sheet of each of them.
I add an example file
Thank you
P:S: I’m sorry for my english
--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/WdRNOGhJj5U/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1ab8aa01-02f8-4a12-804a-0532604032ean%40googlegroups.com.
How can I make automatic the work?