Go-Bruins
asked on
Google sheets script to grab contents of cell two columns to left?
Hi all,
I've written a simple script that grabs the contents of the active cell and assigns it to a var here:
var valueactivecell = activecell.getValue();
I'd also like to grab the contents of a cell that's two columns to the left and one row up. So for example , if the active cell is C2, the cell i'm interested would be in address A1.
How do I achieve this?
Thanks in advance.
I've written a simple script that grabs the contents of the active cell and assigns it to a var here:
var valueactivecell = activecell.getValue();
I'd also like to grab the contents of a cell that's two columns to the left and one row up. So for example , if the active cell is C2, the cell i'm interested would be in address A1.
How do I achieve this?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER