we need that users will enter same exact values in 2 different colums. the
reson being is that the spreadsheet data is uploaded to DB. later on a
program checks that values in each column are matching in order to permit the
request.
if the user enter "Math1" in one column but "Math 1" in the second column,
the program will deney his request.
i am wondering if there is a way that typing values in one column will allso
fill up same values on a different column?

Assuming the 1st "Math1" is in cell A2, enter following formula for 2nd
"Math1":
=A2

This will automatically copy the cell contents into 2nd cell

HTH
--
AP

"michael M" <michael a écrit dans le message de
...
we need that users will enter same exact values in 2 different colums. the
reson being is that the spreadsheet data is uploaded to DB. later on a
program checks that values in each column are matching in order to permit
the
request.
if the user enter "Math1" in one column but "Math 1" in the second column,
the program will deney his request.
i am wondering if there is a way that typing values in one column will
allso
fill up same values on a different column?

One way:

In the second column use a formula that references the first column. In
your example, if the value "Math1" is entered in cell A2, use the formula

=A2

in the other column


"michael M" wrote:

we need that users will enter same exact values in 2 different colums. the
reson being is that the spreadsheet data is uploaded to DB. later on a
program checks that values in each column are matching in order to permit the
request.
if the user enter "Math1" in one column but "Math 1" in the second column,
the program will deney his request.
i am wondering if there is a way that typing values in one column will allso
fill up same values on a different column?