I've got two Google Spreadsheets. Spreadsheet B fetches data from Spreadsheet A using IMPORTRANGE:
What I want to achieve is to be able to write over fetched data inside Spreadsheet B - for example edit chosen cells. Unfortunately, when I try to change even one cell, the whole data from IMPORTRANGE disappears.
Is there any way to do edit data fetched from another Google Sheet?