Please, imagine the following scenario. Document consists of 2 sheets: sheet1, sheet2. Sheet1 has 4 cells filled in. A1, A2, B1, B2. Bonjour, S'il vous plaît, Merci, De rien - all 4 cells are in French. Sheet2 has 4 cells filled in. A1 = googletranslate(Sheet1!A1). Next, it is dragged to autofill. So, we have nice autotranslation whatever a French guy enters on the Sheet1. The problem, however, exists. If a French guy deletes Sheet1!B1 or Sheet1!B2 then autofill can no longer reference Sheet1!B2 as the originally targeted cell does not exist anymore, Error(#Ref) is displayed and we have to again autofill the whole 9 yards.
The question: is there a way to fix a formula in Sheet2 cells to always point to its own x,y coordinate but on the Sheet1?