| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set up formula to update when new column data is entered
How can I set up a formula to update when new column totals are added? Is
this even possible? Here is an example; Current formula shows: =IF(J4I4,"Up Prev Mth", "Under Prev Mth") this compares the data from J4 with I4. What I want it to do is update to: =IF(K4J4,"Up Prev Mth", "Under Prev Mth") when it detects data has been entered into K4. This may require programming at which I am really not qualified. Any help or suggestions to eliminate the manual updates would be appreciated. Thanks, Jim. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set up formula to update when new column data is entered
Possibly modify your formula and prefill your cells
for example, in the cell that would refer to K4 =If(K4="","",IF(K4J4,"Up Prev Mth", "Under Prev Mth")) -- Regards, Tom Ogilvy "Bushman" wrote: How can I set up a formula to update when new column totals are added? Is this even possible? Here is an example; Current formula shows: =IF(J4I4,"Up Prev Mth", "Under Prev Mth") this compares the data from J4 with I4. What I want it to do is update to: =IF(K4J4,"Up Prev Mth", "Under Prev Mth") when it detects data has been entered into K4. This may require programming at which I am really not qualified. Any help or suggestions to eliminate the manual updates would be appreciated. Thanks, Jim. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving formula down 1 row if information is entered into column A | Excel Discussion (Misc queries) | |||
| need formula: # entered in column B will transfer to column D | Excel Worksheet Functions | |||
| Prevent duplicate data from being entered into the same column | Excel Worksheet Functions | |||
| Looking for formula that selects last value entered in a column? | Excel Worksheet Functions | |||
| How do I change data that has been entered in a column to a row? | Excel Discussion (Misc queries) | |||
Linear Mode
