I'm looking for a way to copy and paste data between 2 Google Sheets spreadsheets: in spreadsheet 1 I have a shared planner of 10 people, where each marks in his sheet personal commitments divided between morning and afternoon for each day. There are also two spaces M and P where everyone manually marks commitments with me.

In spreadsheet 2 I have the small jobs assigned to each of them with a summary line that tells me if they are free (they can do up to 3 jobs M and P).

I would like to copy the data in this row in the M and P columns in the sheet of each of them.

CodePudding user response：

If you are looking to copy and paste data, you could use CTRL C CTRL V as suggested by @Jeremy Thille.

If you want to reference data from another sheet, you can do it this way : =NameOfYourSheet!A1, or ='Name Of Your Sheet'!A1 if the name contains spaces.

If the data is on a different spreadsheet, you have to use IMPORTRANGE function. Take a look at

I was not able to explain it and so I send you an image of files.

I have to copy the row "Peter" in Sheet 2 and paste in sheet 1 following the date and sharing of M (morning) and P (afternoon). In suggested way it is too long, and so I thought to GS. In image2 you find the result I would like to have