Hi everyone, is it possible to get it so that an advanced filter (copy to location)copies formulas? because I have a macro that when you click the button it's assigned to, it runs a certain advanced filter, and then has to copy the formula to the cells which need it ( Column D- D?? depending on what is filtered). Any idea of a feature or way to get the advanced filter to extract formulas?? Thanks, Andrew