I am stuck on a section of my macro. I have come to a spot where in column C I have values ranging from 0-999 never in the same order or number of records, Any value that is less than 10 I need to replace with the sum of the adjacent cells in column A+B. example C5 = sum A5+B5.
I am not sure if the find and replace function is correct for what I need to do. I was also looking at filtering the <10 then adding the formula but not sure how to do that either.
Thanks for any help
newb
I am not sure if the find and replace function is correct for what I need to do. I was also looking at filtering the <10 then adding the formula but not sure how to do that either.
Thanks for any help
newb