i am unable to copy & paste filtered data to another sheet.

B

Bhaweshkr

After applying filter whenever i copy or paste the filtered data to another
sheet the total rows selected (apart from the filtered only) be pasted at the
second sheet.

Please suggest what should i do in case of excel 2007.
 
J

Jacob Skaria

Do you mean to say that only the filtered items are copied? If so that is how
excel functions when you copy/paste filtered data.

If this post helps click Yes
 

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

Copy and paste slide from one presentation to another presentation gives an error 2
Copying Portions of Data 0
Unable to view the complete data in filter 0
data spans multiple rows within each cell is collapsed when FILTER is used 0
New computer, how do i move outlook 365 ENTIRELY? 0
Visio shape text disappears upon copy paste 1
Copy/Paste (Clipboard) Issues 1
Filters do not work correctly for table linked to an Access query 1

Top