[SOLVED] increase value to column based on criteria

[scooby99]

Hi everyone! Im new to the forum and hope that someone can help me.

I have a spreadsheet with a lot of stocks that has what I call a "Stop and approve" function.
For example it could look like this.

Sheet2
Input ; Stock ; Output
1 ; "X" ; 1.0214
1 ; "Y" ; 0
2 ; "Z" ; 1.978
....

I would like to create a macro that I have in Sheet1 (my summarize view) to add the value 1 to the input column in Sheet 2 if (Input - Output) < 0.2
So, the result of the macro to the above would be

Sheet2
Input Stock Output
2 ; "X" ; 1.0214
1 ; "Y" ; 0
3 ; "Z" ; 1.978

Can someone help?

[arlu1201]

Maybe it will be a lil easier if you attach a sample workbook.

[scooby99]

Hi! I have attached a sample of it. Hope it clarifies.

[pdjacques]

Hi there, you could try this code, it worked for me on your example:

Please Login or Register  to view this content.

Just substitute "A4:A9" to suit your range of inputs.
Hope this is clear.

Paul

[scooby99]

Hi! It worked perfectly.

Thank you so much!