Data changes in advanced filter

  • Thread starter Thread starter David Sher
  • Start date Start date
D

David Sher

I have just done an advanced filter and copied the results to another sheet,
the data has been copied over with just values, is there any way of copying
the data as is, ie with all the underlying formulae?

Thanks in advance
 
Have the Advanced Filter filter the data only, then select the filtered data,
copy, paste special - all.

Logically, one would think that doing a regular paste and paste special -
all, would do the same thing, but in this case, they do not.
 
Back
Top