automate routine sorting activity using macro

Hi all,

I am working on a project where I am required to audit invoices based on certain parameters.
I have listed the parameters on the attached spreadsheet.

I get a voluminous data running to several thousands of line per day and I need to choose only those lines that satisfy the given parameter.

my parameters are as below
1. all telecom invoices require audit (100%)
2. All invoices whose value is less than zero require 100% audit
3. all invoices with payment method as Wire - Direct require 100% audit
4. all invoices whose invoice amount is greater than 30000 require audit
5. All duplicate URN need 100% audit (sorting based on URN column on result sheet.

I tried to record this macro but not able get the desired output.

Could someone please help me with this?

Regards,
Kiran