Hello community!
I have a sheet of test data called DATA. It has a lot of info, but to simplify my question it might contain many rows of something like this:
<tbody>
</tbody>
In another sheet called SCRIPT I have something like this in a cell.
="Please enter the following:
First Name: "&Data.A1
This produces this result:
Please enter the following:
First Name: Joe
I want to increment the value of the row A1 (from DATA) by a value I set in another cell, G1 for example (in SCRIPT)
If G1 = 0, I get this:
First Name: Joe
G1 = 1, I'd like to increment the row referring to the name by 1 and produce this:
First Name: Bob
G1=2 it should reference A3 in DATA and so on.
I'm hoping to write my script once and use the increment value (G1) to refer to the desired data as needed.
Anyone know how I can make this happen?
I have a sheet of test data called DATA. It has a lot of info, but to simplify my question it might contain many rows of something like this:
A | B | C | |
1 | Joe | Smith | ID number1 |
2 | Bob | Jones | ID number 2 |
<tbody>
</tbody>
In another sheet called SCRIPT I have something like this in a cell.
="Please enter the following:
First Name: "&Data.A1
This produces this result:
Please enter the following:
First Name: Joe
I want to increment the value of the row A1 (from DATA) by a value I set in another cell, G1 for example (in SCRIPT)
If G1 = 0, I get this:
First Name: Joe
G1 = 1, I'd like to increment the row referring to the name by 1 and produce this:
First Name: Bob
G1=2 it should reference A3 in DATA and so on.
I'm hoping to write my script once and use the increment value (G1) to refer to the desired data as needed.
Anyone know how I can make this happen?
Last edited: