Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximization of a Cell
A cell's value is automatically linked to the price of X, which is
constantly changing. How can I capture the highest price of X in a different cell? For example, if the highest price of X (in cell A1 for example) was 90 and then moved down to 50, cell B1 will show 90. But if the price moved higher to 100, it will reflect in B1 as well. Thanks, AMir |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximization of a Cell
On Apr 2, 1:15 pm, "amirstal" wrote:
A cell's value is automatically linked to the price of X, which is constantly changing. How can I capture the highest price of X in a different cell? For example, if the highest price of X (in cell A1 for example) was 90 and then moved down to 50, cell B1 will show 90. But if the price moved higher to 100, it will reflect in B1 as well. Thanks, AMir How is x changed? If it's with code, you could insert an if statement into the code that checks the value of x against the value of cell A1. Or you could just make this it's own routine and call it from the routine that changes the value of X on the sheet. If [A1].Value [B1].Value Then [B1].Value = [A1].Value Else End If |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximization of a Cell
On Apr 2, 1:20 pm, "okrob" wrote:
On Apr 2, 1:15 pm, "amirstal" wrote: A cell's value is automatically linked to the price of X, which is constantly changing. How can I capture the highest price of X in a different cell? For example, if the highest price of X (in cell A1 for example) was 90 and then moved down to 50, cell B1 will show 90. But if the price moved higher to 100, it will reflect in B1 as well. Thanks, AMir How is x changed? If it's with code, you could insert an if statement into the code that checks the value of x against the value of cell A1. Or you could just make this it's own routine and call it from the routine that changes the value of X on the sheet. If [A1].Value [B1].Value Then [B1].Value = [A1].Value Else End If This could also go in the Worksheet_Change event so that anytime the sheet is updated, it fires. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximization of a Cell
On Apr 2, 2:20 pm, "okrob" wrote:
On Apr 2, 1:15 pm, "amirstal" wrote: A cell's value is automatically linked to the price of X, which is constantly changing. How can I capture the highest price of X in a different cell? For example, if the highest price of X (in cell A1 for example) was 90 and then moved down to 50, cell B1 will show 90. But if the price moved higher to 100, it will reflect in B1 as well. Thanks, AMir How is x changed? If it's with code, you could insert an if statement into the code that checks the value of x against the value of cell A1. Or you could just make this it's own routine and call it from the routine that changes the value of X on the sheet. If [A1].Value [B1].Value Then [B1].Value = [A1].Value Else End If A1 is automatically linked to an outside application that provides data to excel constantly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |