Hi All,
In a nutshell, I need to have the contents in cell A on sheet 1 to copy to cell B on sheet 2 for a form I am creating.

Restrictions:
- Do not want to use macros
- Do not want the user to see the formula

The issue I am having is that I don't want to write the formula in cell B saying =cellA because then the user can see the formula. If I hide the contents of the cell, then the user not only will be unable see the contents in the formula bar, but once he/she types a letter in the cell, the formula disappears.

Is it possible to write a formula in a cell I am going to hide and say if true then make cell A = cell b?