Hi All!
I have a workbook that calculates a quantity of shares to order based off a realtime stock quote that is ever changing. The workbook appears as below:
$Amt available | Last Stock Price | Quantity to order |
(Fixed)............| (Variable).........| =roundup($amt avail/last price)
The quantity to order field changes every second the Last Stock Price column pulls in real time market data, and then that feeds into a separate worksheet that generates my order list. Right now, that sheet simply pulls the quantity in the respective Quantity to Order cell. I.e. Cell C2 in the 'Order List' worksheet is: ='Calculations'!C2
What I would like is for that cell to instead return the highest calculated value, rather than the current value of CalculationsC2. In other words, if CalculationsC2 goes from 1000 to 1001 to 999, I want cell OrderListC2 to hold the value of 1001, preferably via formula rather than vba.
Any ideas on how to do something like this, please let me know!!!!
Bookmarks