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

Dealing with the error: unable to filter on excel hc home school 0
Dates In Excel 5
Duplicate pst, or is it? 1
need help on either doing a loop and counting specific values orusing subtotal function 2
sqlite-odbc write conflict 2
how to copy and paste value from one sheet to another 4
Sharing Access MDB or Accdb with client using older or newer version of Office 1
I have lost 6 months work, how can i get my file back 1

Top