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.