Google Sheets: I would like to get the row index (or the value inside) of the selected cell, from the specific sheet, even the sheet which is currently not in focus. Lets say, I select a cell in sheet "A", and then move to sheet "B". From here I would like to retrieve the selected cell row index (or the value insde of that selected cell) on sheet "A".
So no method of "get Active Cell" or "get Current Cell" will work, because those methods are only refering to the currently focused sheet. I just couldn`t find any solution.
Bookmarks