| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep getting #N/A versus Dollar amts | Excel Discussion (Misc queries) | |||
| automate column length | Excel Discussion (Misc queries) | |||
| Automate column selection | Setting up and Configuration of Excel | |||
| need to automate data into a column | Excel Discussion (Misc queries) | |||
| Separating Over/Short Amts. | Excel Worksheet Functions | |||
Hybrid Mode
