View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DianeG DianeG is offline
external usenet poster
 
Posts: 59
Default Calculations in filtered columns

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?


"Eduardo" wrote:

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

"Dianeg" wrote:

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