In F1

=E1 and drag down

Whatever is entered into e1 will be mirrored in F1

"acss" wrote:

I have column E and F which contains dollar amounts and users need to enter
same dollar amounts in both columns. For example column E is 100 and column F
needs to be 100 as well. Is there a way to ensure both columns reflect same
amounts after entry to avoid sum errors later on?