Sort Table if ether of the 2 Columns meet the criteria with VBA

[Celticfc]

I have a table where in C or F, you can have the ID of employees.

Is there a way to sort this table if either of the Columns meet the criteria:"AZ83764"?

Many thanks in advance

 

[Joe4]

I think people aren't sure what you mean.
How exactly is your criteria supposed to work?
Are you looking to see if ANY value in column C or F is equal to the value "AZ83764" (or is that the value in cell "AZ83764")?
What if that value appears in both columns?
And what column(s) do you want to sort by?

Many times, a simple example will go a long way in showing us what you are actually trying to do.