Macro for Filter data

[Negi1984]

Hi All,

I have data in column E & F in below sample format :-
[TABLE="width: 279"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GRO1
[/TD]
[TD]GR1
[/TD]
[/TR]
[TR]
[TD]12345678
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]Before GRO process
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]No initial GRO required
[/TD]
[TD="align: center"]TRUE
[/TD]
[/TR]
[TR]
[TD]No initial GRO required
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]Multitech
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74704238
[/TD]
[TD="align: center"]TRUE
[/TD]
[/TR]
[TR]
[TD]74704515
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74704510 - Amendment
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74705102
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74704962
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74705231
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74704531- Rejected 74704532
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD="align: right"]74705192
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74704531- Rejected -74704532
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74705193
[/TD]
[TD="align: center"]TRUE
[/TD]
[/TR]
[TR]
[TD]74704512 - Amendment 74704513
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]74705017
[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
[TR]
[TD]
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
[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

Sample Output is below :-


[TABLE="width: 280"]
<tbody>[TR]
[TD="colspan: 2"]Output[/TD]
[/TR]
[TR]
[TD]GRO1[/TD]
[TD]GR1[/TD]
[/TR]
[TR]
[TD]12345678[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]74705192[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74704515[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74705102[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74704962[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74705231[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74704531- Rejected 74704532[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74704531- Rejected -74704532[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74704512 - Amendment 74704513[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]74705017[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]