Increase current cell ONLY when different than target cell

[Kemosabe]

I am looking for a way to avoid the circular reference issue. I would like to monitor a cell that is being incremented and decremented so that I can automatically retain the highest and the lowest values that were entered into that specific cell over time. Since the data is only entered into that specific cell and not retained in for example a column, the MAX/MIN option is not usable in this case.

More simply stated, is there a way to put a formula in a specific cell ( A1 ) that will equal the target cell ( B1 ) only when that target cell ( B1 ) is greater than A1?

Thank you.

 

[Scott Huish]

Weird, it let me do it just fine. But that is better.

 

[Kemosabe]

Try this for my code.
Open a new workbook and Rightclick the Sheet1 tab. Select "View Code".
Paste the code I posted in the white panel. Close the Visual Basic Editor(ALT+Q) Now enter 10 In B1, In B2 enter 5.

Let me know if you can't get it to work.

lenze

... got back from vacation last night and just had a chance to try this. It does exactly what I was looking for. Thanks Lenz and all for your help. It is appreciated.........