Google-sheets – How to copy the contents of a single cell from one Google spreadsheet to another Google Speadsheet

google sheets

I am trying to copy the content of one cell of a Google speadsheet to another cell in a different Google spreadsheet. I have tried the formula

(=Exportrange("spreadsheet-key", "Sheet-name! range"))

But it is not working. Probably because my formula looks like

(=Exportrange("Spreadsheet name", "Sheet-name! C19:C19"))

Looking for a solution on this.

Best Answer

There is no "exportrange" in Google Sheets.

Use importrange where the first parameter is the URL of the spreadsheet, from which the data is to be taken, and the second points to a cell. It will look like this, where ... depends on the source spreadsheet:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/.../edit#gid=0", "Sheet1!A1")

The first time importrange is used, it displays #REF! message. Hover over it to see a prompt to allow import; this only happens once for a given pair of spreadsheets.

Related Solutions

Google-sheets – Copy one Google Spreadsheet to another

NO - copying google spreadsheet is severly limited and will not copy over YOUR range permission settings but maddeningly then gives everyone edit access - it should at least default to comment access only - its VERY frustrating. So in short the ''copy'' is not a copy.

If anyone discovers that this answer is wrong - PLEASE TELL ME !

Google Sheets – Periodically Stamp Sheet Contents

var sheet1 = SpreadsheetApp.getActiveSheet.getSheetByName("mySheet1");
var sheet2 = SpreadsheetApp.getActiveSheet.getSheetByName("mySheet2");
sheet1.getrange("A1:C7").setvalues(sheet1.getrange("B1:D7").getvalues);

Where A1:C7 is the destination range and B1:D7 is the source range. I have not tested it but it should be like this.

Best Answer

Related Solutions

Google-sheets – Copy one Google Spreadsheet to another

Google Sheets – Periodically Stamp Sheet Contents

Related Topic