$$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Sach1810
Hi, I have two cells lets say a1 and a2 both of which are continually updating from a live feed. I would like to be able to track what the highest number of a1 has been and what the lowest number of cell a2 has been. Your help would be much appreciated as I am new to programming Many Thanks

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Abhishek Jain
Can you send an example file ? That would help to understand better. Thanks, On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 sach1...@googlemail.com wrote: Hi, I have two cells lets say a1 and a2 both of which are continually updating from a live feed. I would like to be able to track what the

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread rf1234 rf1234
Hello Dear Have you Tried MAX() Please let me know,if more help required. Hope it will Help Happy To Help :) Shyam On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 sach1...@googlemail.com wrote: Hi, I have two cells lets say a1 and a2 both of which are continually updating from a live feed. I

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Paul Schreiner
You could: store initial values in a hidden cell. Create a change event for the worksheet that compares the cell contents to the hidden cells and update if the contents meet the criteria. (if a1 H1 then H1 = a1) (if a2 H2 then H2 = a2) let me know if you need help with the change events.

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

2010-03-05 Thread Paul
Decided to go to the GoogleGroups site so that I can see the whole discussion thread. I'll explain in detail. To create a change event: Right-click on the sheet taband select View Code At the top of the editor code window is a set of pull-downs. In the left pull-down, select WorkSheet. It will