hi,

i want to apply a filter to a cell which is called total cost
that total cost could be in any column after i have used my pivot table

how do you tell the macro to filter on total cost then look for none blanks

thanks steve