Calculations in filtered columns

  • Thread starter Thread starter Dianeg
  • Start date Start date
D

Dianeg

Is there any way to perform an advanced filter on columns with calculations
in them and copy the data with calculations to another location.? It copies
the extracted data as values only.

Thanks
 
With the filtered data selected press CTL+G, special, visible cells only,
CTRL + C, go to where you want to copy the information, paste special, values
 
Thanks for the response but I don't think I explained myself properly. I
want the calculations to copy over not the values.
Any ideas?
 
If you mean you want the formulas copied, then use Paste
Special...>Formulas. If not, then tell us what you mean by 'calculations'

Regards,
Fred
 
Back
Top