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?