To all the Excel masters, I'm trying to create a very simple macro but I've never used VBA before. I come from a background with lower level programming (hardware level up to C/C++) and from that point of view, VBA appears quite disgusting 
Here's what I'm trying to do:
1) Automatically run the macro when the first cell changes
2) Compare the value of the first cell to the second cell
3) If the first cell value is less than the second cell value, update the second cell to this value
I've had a bit of a look around on the net and had a couple of attempts myself with no results. Thanks for any help!

Here's what I'm trying to do:
1) Automatically run the macro when the first cell changes
2) Compare the value of the first cell to the second cell
3) If the first cell value is less than the second cell value, update the second cell to this value
I've had a bit of a look around on the net and had a couple of attempts myself with no results. Thanks for any help!
Comment