Macro for Filter data

[Negi1984]

Hi All,

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>