I would appreciate any help putting together some code that I can run to copy and paste from one cell to another based on value. Here is what I am looking for:
I have a list of stocks in 32 rows. Column B or range "column_last" has the current price. Column R or range "column_high_watermark" has the value of the high watermark and column S or range "column_watermark_date" has the date that watermark takes place.
I would like to run the macro and have it look at each row, from 2 to 32 and compare column B value and see if it is bigger than column R value. If it is TRUE then it would copy column B value and paste the value only to column R and then paste in the current date into column S. Then, it would go to the next row until it has finished row 33.
How would you best perform this? What other info is needed?
Cheers and thank you in advance.
Guy
I have a list of stocks in 32 rows. Column B or range "column_last" has the current price. Column R or range "column_high_watermark" has the value of the high watermark and column S or range "column_watermark_date" has the date that watermark takes place.
I would like to run the macro and have it look at each row, from 2 to 32 and compare column B value and see if it is bigger than column R value. If it is TRUE then it would copy column B value and paste the value only to column R and then paste in the current date into column S. Then, it would go to the next row until it has finished row 33.
How would you best perform this? What other info is needed?
Cheers and thank you in advance.
Guy