Hi Merjet..thanks for the information, but my problem is I need to do
it via a macro and it should look into columns C, G & I and exclude
the other columns and I need to do it across all the spreadsheets.
Also I cannot run Advanced filter on specific columns. These 5
workbooks are generated by a different macro.

Thanks