Automate Column Amts
 

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?

Automate Column Amts
 

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?

Automate Column Amts
 

Yes. That works but it does leave a trail of zeros in the column. Is there
code or conditional formating that would change the cell color if amounts did
not match in both columns?

"Mike H" wrote:

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?

Automate Column Amts
 

If you followed Mike's suggestion there would be no possiblity of amounts not
matching.

To hide the zeros until data is entered use this trapper.

In F1 enter =IF(E1="","",E1)

Drag/copy down as far as you wish.

Have users enter data ONLY in column E


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 13:42:00 -0700, acss wrote:

Yes. That works but it does leave a trail of zeros in the column. Is there
code or conditional formating that would change the cell color if amounts did
not match in both columns?

"Mike H" wrote:

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?