Data changes in advanced filter

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
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding a control button with a filter 2
need help on either doing a loop and counting specific values orusing subtotal function 2
missing data w/ advanced filter 6
Advanced Filter how to include columns 1
Advance Filter Problem 3
Advanced filter I think 4
Calculations in filtered columns 4
Copy Formulas of Filtered Data 1

Top