figment222
New Member
- Joined
- Mar 6, 2015
- Messages
- 48
Hello,
I can usually find the answers I need online and modifying to suit my needs, but I'm just getting started in VBA and I have not had success finding a solution for this issue and would appreciate any help.
I have a range of cells in column O that I want to compare with the values in column B and for the ones that match, I want the cell in Column C to say: True. I could easily do this with a formula, but I can't have a formula in column C.
B22:B36 has static values. O22:O36 will populate a matching value, based on a formula. C22:C36 needs to either be true or false. If O22 = B22, then change C22 to True. Check the rest of the range. If O28 = B28, then make C28 say True, else, have it say FALSE. etc.
Thank you for your time.
I can usually find the answers I need online and modifying to suit my needs, but I'm just getting started in VBA and I have not had success finding a solution for this issue and would appreciate any help.
I have a range of cells in column O that I want to compare with the values in column B and for the ones that match, I want the cell in Column C to say: True. I could easily do this with a formula, but I can't have a formula in column C.
B22:B36 has static values. O22:O36 will populate a matching value, based on a formula. C22:C36 needs to either be true or false. If O22 = B22, then change C22 to True. Check the rest of the range. If O28 = B28, then make C28 say True, else, have it say FALSE. etc.
Thank you for your time.
Last edited by a moderator: