SensualCarrots
New Member
- Joined
- Mar 21, 2015
- Messages
- 46
I'm looking for a macro to do the following:
Column A is given data.
Column B is what I want to happen when the macro is executed.
<tbody>
</tbody>
I would imagine it will just be a copy and paste of the code, modifying the search parameters. I can handle that part. Just need the base code to find the data and return the first found value.
Curve Ball:
Sometimes my cells will contain part of the same string of an entire other cell. For example, one cell in my search range may be 1A, and another may be 1A.1 I need to make sure it is matched to the whole word, as searching for 1A may result in true if 1A.1 is present, but 1A is not. Thanks in advance for your help!
Column A is given data.
Column B is what I want to happen when the macro is executed.
A | A |
A | B |
A | C |
C | D |
B | |
B | |
C | |
C | |
D | |
A |
<tbody>
</tbody>
I would imagine it will just be a copy and paste of the code, modifying the search parameters. I can handle that part. Just need the base code to find the data and return the first found value.
Curve Ball:
Sometimes my cells will contain part of the same string of an entire other cell. For example, one cell in my search range may be 1A, and another may be 1A.1 I need to make sure it is matched to the whole word, as searching for 1A may result in true if 1A.1 is present, but 1A is not. Thanks in advance for your help!