Data changes in advanced filter
 

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

Data changes in advanced filter
 

Try: Paste Special...Formulas

Regards,
Fred

"David Sher" wrote in message
...
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

Data changes in advanced filter
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"David Sher" wrote:

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