Hello!
I'm trying to create a macro that does the following:
1. Find all instances of the value "#N/A" in Column C
2. When it finds "#N/A" in Column C compare the value in Column B of that same row to Column B of the row above it.
3. If Column B matches the Row above it, then copy Column C from that row into the Row below it.
4. If Column B does not match the row above it, highlight that row Blue.
Here is what the input would look like:
<tbody>
</tbody>
And here's what I'm looking for the Output to look like:
<tbody>
</tbody>
So far I have a loop that looks for all instances of "#N/A" and highlights if they don't match, but does anyone have any ideas of how I would code the "Find/Replace" part of that? Thanks very much for any help!
I'm trying to create a macro that does the following:
1. Find all instances of the value "#N/A" in Column C
2. When it finds "#N/A" in Column C compare the value in Column B of that same row to Column B of the row above it.
3. If Column B matches the Row above it, then copy Column C from that row into the Row below it.
4. If Column B does not match the row above it, highlight that row Blue.
Here is what the input would look like:
Policy | Company Name | Client Number | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> | #N/A | ||||
<tbody> </tbody> |
<tbody> </tbody> | #N/A |
<tbody>
</tbody>
And here's what I'm looking for the Output to look like:
Policy | Company Name | Client Number |
ABC123 | Fake Company | 45678 |
ABC123 | Fake Company | 45678 |
DEF456 | Dummy Company | #N/A |
<tbody>
</tbody>
So far I have a loop that looks for all instances of "#N/A" and highlights if they don't match, but does anyone have any ideas of how I would code the "Find/Replace" part of that? Thanks very much for any help!