Hi All,
I have data in column E & F in below sample format :-
<tbody>
</tbody>
Sample Output is below :-
<tbody>
</tbody><colgroup><col><col></colgroup>
I have data in column E & F in below sample format :-
GRO1 | GR1 |
12345678 | FALSE |
Before GRO process | FALSE |
No initial GRO required | TRUE |
No initial GRO required | FALSE |
Multitech | FALSE |
74704238 | TRUE |
74704515 | FALSE |
74704510 - Amendment | FALSE |
74705102 | FALSE |
74704962 | FALSE |
74705231 | FALSE |
74704531- Rejected 74704532 | FALSE |
74705192 | FALSE |
74704531- Rejected -74704532 | FALSE |
74705193 | TRUE |
74704512 - Amendment 74704513 | FALSE |
74705017 | FALSE |
Now I need to filter it with Macro and condition will be Column F should be false and and column E should contains all the numbers and rows if it contains Rejected /Amendments in beginning and end of the text. Could you please assist , how to write the VBA code for the same. Regards, Rajender |
<tbody>
</tbody>
Sample Output is below :-
Output | |
GRO1 | GR1 |
12345678 | FALSE |
74705192 | FALSE |
74704515 | FALSE |
74705102 | FALSE |
74704962 | FALSE |
74705231 | FALSE |
74704531- Rejected 74704532 | FALSE |
74704531- Rejected -74704532 | FALSE |
74704512 - Amendment 74704513 | FALSE |
74705017 | FALSE |
<tbody>
</tbody><colgroup><col><col></colgroup>
Last edited: